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 the owner of the view, or have one of the following privileges:
Context and remarks
You may need to alter a view if the 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.
In Sybase Central, use the SQL Anywhere 16 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.
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 © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|