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

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Usage » Tables, views, and indexes » Views » Regular views

 

Dropping a regular view (Sybase Central)

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.

Prerequisites

You must be a user with DBA authority or be the owner of the regular view.

You must drop any INSTEAD OF triggers that reference the view before the view can be dropped.

Context and remarks

Many.

 Drop a regular view using Sybase Central
  1. Use the SQL Anywhere 12 plug-in to connect to the database.

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

  3. Right-click the view and click Delete.

  4. Click Yes.

Results

The definition for the regular view is deleted from the database.

Next

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.

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

 See also