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.
Privileges Required for Stopping a Violations Table

Privileges Required for Stopping a Violations Table

To stop a violations or a diagnostics table for a given target table, you must meet one of the following requirements:

You must have the DBA privilege on the database.
You must be the owner of the target table and have the Resource privilege on the database.
You must have the Alter privilege on the target table and the Resource privilege on the database.