Syntax
The DROP statement has the following format:
[EXEC SQL] DROP objecttype objectname [WITH with_clause]
objecttype
Specifies the type of object, which can be one of the following keywords:
TABLE
VIEW
INDEX
objectname
Specifies the name of a table, view, or index.
WITH with_clause
Specifies a comma‑separated list of valid Enterprise Access product WITH clause options. For an overview of the Enterprise Access product WITH clause, see the chapter "OpenSQL Features.” For a list of the valid WITH clause options for a specific Enterprise Access product, see the product guide.