Was this helpful?
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.
The DROP INTEGRITY statement has the following format:
[EXEC SQL] DROP INTEGRITY ON tablename ALL | integer {, integer};
tablename
Specifies the name of the table for which integrity constraints are to be dropped.
ALL
Removes all the constraints currently defined for the specified table.
integer (,integer)
Removes individual constraints. To obtain the integer equivalents for integrity constraints, execute the HELP INTEGRITY statement.
Embedded Usage
In an embedded DROP INTEGRITY statement, tablename or integer cannot be represented with host language variables.
Permissions
You must own the table.
Related Statements
CREATE INTEGRITY
Last modified date: 11/28/2023