Progress
SQL-92
Guide and Reference


DROP VIEW Statement

Deletes the view from the database.

SYNTAX

DROP VIEW [ owner_name.]view_name ; 

owner_name

Specifies the owner of the view.

view_name

Names the view to drop.

EXAMPLE

DROP VIEW newcustomers ; 

NOTES

AUTHORIZATION

Must have DBA privilege or ownership of the view.

SQL COMPLIANCE

SQL-92, ODBC Core SQL grammar

ENVIRONMENT

Embedded SQL, interactive SQL, ODBC applications, JDBC applications

RELATED STATEMENTS

CREATE VIEW Statement


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