8. SQL Statements : DROP INTEGRITY : Syntax
 
Share this page                  
Syntax
The DROP INTEGRITY statement has the following format:
[EXEC SQL] DROP INTEGRITY ON table_name ALL | integer {, integer};
table_name
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.