These topics describe various aspects of creating and managing views:

• Working with View Dependencies contains examples of listing view information and determining what views depend on a certain object.

Views ignore ORDER BY and operations stored in the view.

Dropping Views

DROP VIEW topten;

The command also removes all dependent objects. As an example, if another view depends on the view which is about to be dropped, the other view will be dropped as well. Without the CASCADE option, the DROP VIEW command will fail.