Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
DROP TABLE statementUse the DROP TABLE statement to remove a table with its associated indexes and data. This statement is an extension to the ANSI/ISO standard for SQL.

DROP TABLE statement

Use the DROP TABLE statement to remove a table with its associated indexes and data. This statement is an extension to the ANSI/ISO standard for SQL.

Syntax


Element	Description	Restrictions	Syntax
`owner`	Name of table owner	Must own the table	Owner name
`synonym`	Local synonym for a table that is to be dropped	The synonym and its table must exist, and USETABLENAME must not be set to 1	Identifier
`table`	Name of a table to drop	Must be registered in the systables system catalog table of the local database	Identifier

Usage

You must be the owner of the table or have the DBA privilege to use the DROP TABLE statement.

If you include the optional IF EXISTS keywords, the database server takes no action (rather than sending an exception to the application) if no table of the specified name is registered in the current database.

You cannot drop a system catalog table.

If you issue a DROP TABLE statement, DB-Access does not prompt you to verify that you want to delete an entire table.