Example of Dropping a Violations and Diagnostics Table

Enterprise Edition Home | Express Edition Home | Previous Page | Next Page SQL Statements > STOP VIOLATIONS TABLE >

Example of Dropping a Violations and Diagnostics Table

After you execute the STOP VIOLATIONS TABLE statement in the preceding example, the cust_subset_vio and (for Dynamic Server) 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;

Privileges Required for Stopping a Violations Table

To stop a violations table (and for Dynamic Server, 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.

Related Information

Related statements: SET Database Object Mode and START VIOLATIONS TABLE

For a discussion of database object modes and violation detection, see the IBM Informix Guide to SQL: Tutorial.