Dropping a View - Firebird

The DROP VIEW statement enables a view’s owner to remove its definition from the database. It does not affect the base tables associated with the view.

This is the syntax:

DROP VIEW view-name;

The DROP VIEW operation will fail if you are not logged in as the owner of the view or if the view is used by another object, such as a view, a stored procedure, a trigger on another view, or a table or a CHECK constraint definition.

The following statement removes a view definition:

DROP VIEW SUB_DEPT;


All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

Firebird Topics