Drop Integrity Statement
The drop integrity statement removes the specified integrity constraints from a table.
This statement has the following syntax:
drop integrity on table_name ALL | integer {, integer};
When integrities are dropped from a table, the DBMS Server updates the date and timestamp of that table.
After integrities are dropped from a table, the DBMS Server recreates query plans for repeat queries and database procedures when an attempt is made to execute the repeat query or database procedure.
Note: The drop integrity statement does not remove constraints defined using the
create table statement (see
Create Table Statement).