DROP VIEW

Removes a view from the database.

SYNTAX

view_name Name of the view you want to remove from the database.

DESCRIPTION

The DROP VIEW command removes an existing view from the database. To execute the DROP VIEW command you must be the view owner, or have DBA or SYSADM security privileges.

When you drop a view, DBMaker will automatically drop all views based on the view you are dropping. You cannot drop system views.

EXAMPLE

The following example drops the view SalesStaff.

DROP VIEW SalesStaff

RELATED COMMANDS

< DROP TRIGGER | Contents | END BACKUP >

Copyright 2002 SYSCOM Computer Engineering Co. All rights reserved.