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™.
STOP VIOLATIONS TABLE statementUse the STOP VIOLATIONS TABLE statement to drop the association between a target table, its violations table, and its diagnostics table. This statement is an extension to the ANSI/ISO standard for SQL.
Example of Dropping the Violations and Diagnostics Tables

Example of Dropping the Violations and Diagnostics Tables

After you execute the STOP VIOLATIONS TABLE statement in the preceding example, the cust_subset_vio and the cust_subset_dia tables continue to exist, but they are no longer associated with the cust_subset table. Instead they now have the status of regular database tables. To drop these two tables, enter the following statements:

DROP TABLE cust_subset_vio;
DROP TABLE cust_subset_dia;

If you had previously issued the DROP TABLE statement without the RESTRICT keyword to successfully drop the cust_subset table, then the statements above would not be necessary, because dropping the target table in cascade mode implicitly drops any associated violations table and diagnostics table.