Drop Integrity

Valid in: SQL, ESQL

The Drop Integrity statement removes the specified integrity constraints from the specified table. To remove all the constraints currently defined for the specified table, use the keyword all. To remove individual constraints, use the integer list. To obtain the integer equivalents for integrity constraints, execute the help integrity statement.

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.

Syntax

The Drop Integrity statement has the following format:

[EXEC SQL] DROP INTEGRITY ON table_name all | integer {, integer};

Embedded Usage

In an embedded Drop Integrity statement, table_name or integer cannot be represented with host language variables.

Permissions

You must own the specified table.

Related Statements

Create Integrity

Examples: Drop Integrity

The following are Drop Integrity statement examples:

1. Drop integrity constraints 1, 4, and 5 on job.

   drop integrity on job 1, 4, 5;

2. In an application, drop all the constraints against the exhibitions table.

   exec sql drop integrity on exhibitions all;