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 has some extensions compared to the ANSI/ISO standard for SQL.
Tables That Cannot Be Dropped

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;

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.