DROP VIEW

Remove one or more views from the current database.

Syntax
      DROP VIEW [schema.] view [...,n ] [;]

Key
   view    Name of the view to be dropped.

DROP VIEW can be executed against indexed views.

Example

DROP VIEW MyView;

# We always did feel the same, We just saw it from a different point of view# - Bob Dylan, Tangled Up In Blue

Related commands:

CREATE VIEW
ALTER VIEW
Equivalent Oracle command: DROP VIEW


 
Copyright © 1999-2021 SS64.com
Some rights reserved