You edit a regular view by editing its definition in the database. For example, if you want the view to contain data from an additional table, you would update the view definition to join the table data with the existing data sources in the view definition.
You must be a user with DBA authority or be the owner of the regular view.
Context and remarks
A view definition is out of date (won't compile because of a schema change in the underlying data), needs columns added or removed, or requires changes related to its settings.
You cannot rename an existing view. Instead, you must create a new view with the new name, copy the previous definition to it, and then drop the old view.
Use the SQL Anywhere 12 plug-in to connect to the database.
In the left pane, double-click Views.
Select the view.
In the right pane, click the SQL tab and edit the view's definition.
If you want to edit multiple views, you can open separate windows for each view rather than editing each view on the SQL tab in the right pane. You can open a separate window by selecting a view and then clicking File » Edit In New Window.
Click File » Save.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|