DROP VIEW

From InterBase
Jump to: navigation, search

Go Up to Statement and Function Reference (Language Reference Guide)


Removes a view definition from the database. Available in gpre, DSQL, and isql.

DROP VIEW name;
Important: In SQL statements passed to DSQL, omit the terminating semicolon. In embedded applications written in C and C++, and in isql, the semicolon is a terminating symbol for the statement, so it must be included.
Argument Description

<name>

Name of an existing view definition to drop

Description: DROP VIEW enables a view’s creator to remove a view definition from the database if the view is not used in another view, stored procedure, or CHECK constraint definition.

A view can be dropped by its creator, the SYSDBA user, or any user with operating system root privileges.

Example: The following isql statement removes a view definition:

DROP VIEW PHONE_LIST;

See Also

Advance To: