Name

DROP VIEW

Synopsis

DROP VIEW
[schema.]view_name

Removes a view (view_name) from the database.

Note

The view to be dropped must be in your schema, or you must have the DROP ANY VIEW privilege to remove a view from another schema.

Example

The following example removes scott’s emploc view from the database:

DROP VIEW scott.emploc
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset