DROP VIEW
From InterBase
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
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;