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

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Working with Database Objects » Working with views

Altering views Next Page

Dropping views

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

View deletions and view dependencies

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

To determine whether there are views dependent on a view, use the sa_dependent_views system procedure. See sa_dependent_views system procedure.

For information on how view dependencies affect view alterations, see View dependencies.

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

  2. Open the Views folder.

  3. Select the desired view and then choose Edit > Delete.

To drop a view (SQL)
  1. Connect to the database as the DBA, or as the owner of the view.

  2. Execute a DROP VIEW statement.

  3. Examples

    Remove a view called DepartmentSize.

    DROP VIEW DepartmentSize;

    For more information, see DROP statement.