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 SS64.com 1999-2014
Some rights reserved