Small. Fast. Reliable.
Choose any three.
DROP VIEW

drop-view-stmt:

DROP VIEW IF EXISTS schema-name . view-name

R-27002-52307:[The DROP VIEW statement removes a view created by the CREATE VIEW statement. ] R-00359-41639:[The view definition is removed from the database schema, but no actual data in the underlying base tables is modified. ]

R-18673-21346:[The view to drop is identified by the view-name and optional schema-name specified as part of the DROP VIEW statement. This reference is resolved using the standard procedure for object resolution. ]

R-25558-37487:[If the specified view cannot be found and the IF EXISTS clause is not present, it is an error. ] R-07490-32536:[If the specified view cannot be found and an IF EXISTS clause is present in the DROP VIEW statement, then the statement is a no-op. ]

This page last modified on 2022-01-08 05:02:57 UTC