Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - SQL Usage » Creating Databases » Working with database objects » Working with regular views

 

Drop regular views

You can drop a regular view in both Sybase Central and Interactive SQL.

If you drop a regular view that has dependent views, then the dependent views are made INVALID as part of the drop operation. The dependent views are not usable until they are changed or the original dropped view is recreated. See Alter regular views.

To determine whether a regular view has dependent views, use the sa_dependent_views system procedure. See sa_dependent_views system procedure.

For information about regular views are impacted by changes to their underlying objects, see View dependencies.

♦  To drop a regular view (Sybase Central)
  1. Connect to the database as a user with DBA authority, or as the owner of the regular view.

  2. In the left pane, double-click Views.

  3. Right-click the view and choose Delete.

  4. Click Yes.

♦  To drop a regular view (SQL)
  1. Connect to the database as a user with DBA authority, or as the owner of the regular view.

  2. Execute a DROP VIEW statement.

Examples

Remove a regular view called DepartmentSize.

DROP VIEW DepartmentSize;

See DROP VIEW statement.