Drop a view when it is no longer required. You must also drop a view (and recreate it) when you want to change the name of a view.
You must be the owner, or have the DROP ANY VIEW or DROP ANY OBJECT system privilege.
You must drop any INSTEAD OF triggers that reference the view before the view can be dropped.
In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.
In the left pane, double-click Views.
Right-click the view and click Delete.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|