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.

Examples

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