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.
Tables That Cannot Be DroppedRestrictions exist on the types of tables that you can drop.

Tables That Cannot Be Dropped

Restrictions exist on the types of tables that you can drop.

You cannot drop any system catalog table.
You cannot drop a table that is not in the current database.
You cannot drop a violations table or a diagnostics table.
Before you can drop such a table, you must first issue a STOP VIOLATIONS TABLE statement on the base table with which the violations and diagnostics tables are associated.

The following example removes two tables in the current database. Both are owned by joed, the current user. Neither table has an associated violations or diagnostics table, nor a referential constraint or view defined on it.

DROP TABLE customer;
DROP TABLE stores_demo@accntg:joed.state;