8. SQL Statements : DROP : Syntax
 
Share this page                  
Syntax
The DROP statement has the following format:
[EXEC SQL] DROP [object_type] [IF EXISTS] [schema.]object_name {, [schema.]object_name};
object_type
Specifies the type of object to drop, which can be one of the following keywords:
TABLE
VIEW
INDEX
The following object types can also be dropped. These DROP statements are described under separate entries in this chapter:
DBEVENT (see page DROP DBEVENT)
GROUP (see page DROP GROUP)
INTEGRITY (see page DROP INTEGRITY)
LINK (Applies to Ingres Star only. See the Ingres Star User Guide.)
LOCATION (see page DROP LOCATION)
PROCEDURE (see page DROP PROCEDURE)
PROFILE (see page DROP PROFILE)
ROLE (see page DROP ROLE)
RULE (see page DROP RULE)
SECURITY_ALARM (see page DROP SECURITY_ALARM)
SEQUENCE (see page DROP SEQUENCE)
SYNONYM (see page DROP SYNONYM)
USER (see page DROP USER)
IF EXISTS
Suppresses error reporting for the specified object if the object does not exist or exists but is not owned by you. The IF EXISTS option can be used only for object types TABLE, VIEW, INDEX, SYNONYM, PROCEDURE, LINK.
object_name
Specifies the name of a table, view, index, or other valid object.