Progress
SQL-89
Guide and Reference


Deleting Views

The DROP VIEW statement deletes one or more views from the database. The DROP VIEW statement has the following syntax.

SYNTAX
DROP VIEW view-name 

The following example deletes a view named my_view.

DROP VIEW my_view. 

If you have defined other views in relation to the view you are deleting, Progress/SQL does not permit the deletion. The underlying tables are not affected by deleting the view.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095