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™.
ALTER TABLE statementUse the ALTER TABLE statement to modify the schema of an existing table.
DROP AUDIT ClauseUse the DROP AUDIT clause with the ALTER TABLE command to remove it from the set of tables that is audited when selective row-level auditing is enabled.

DROP AUDIT Clause

Use the DROP AUDIT clause with the ALTER TABLE command to remove it from the set of tables that is audited when selective row-level auditing is enabled.

The DROP AUDIT clause affects only tables that have been flagged for inclusion in selective row-level auditing. If you have not created or altered the table with the WITH AUDIT clause or ADD AUDIT clause, it is not necessary to use DROP AUDIT to exclude it from the set of tables that are audited at the row level.

Removing the AUDIT attribute from a table does not disable or change selective row-level auditing of other tables in the database.

You must be a DBSSO to run the ALTER TABLE command with the DROP AUDIT clause.