DROP INTEGRITY
Valid in: SQL, ESQL, OpenAPI, ODBC, JDBC, .NET
The DROP INTEGRITY statement removes the specified integrity constraints from a table.
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 and ALTER TABLE statements.