AltEnableAddColnChk

Chapter 3 DBMS Reference Guide

AltEnableAddColnChk

Indicates if a column check constraint, built from the check parameters of the column, can or cannot be added in a table using an alter table statement.

Value Result

Yes AddColnChck can be used to modify the column check constraint in an alter table statement.

No The modify database process does the following:

Drops the foreign key constraints

Creates a temporary table with the same structure and columns as the table before the column check constraint addition

Inserts the rows from the old table to the new temporary table

Drops the actual table

Creates a new table with the new column check constraint

Inserts the rows from the temporary table to the new table

Creates the indexes and the constraints on the new table

Value	Result
Yes	`AddColnChck` can be used to modify the column check constraint in an `alter table` statement.
No	The modify database process does the following: Drops the foreign key constraints Creates a temporary table with the same structure and columns as the table before the column check constraint addition Inserts the rows from the old table to the new temporary table Drops the actual table Creates a new table with the new column check constraint Inserts the rows from the temporary table to the new table Creates the indexes and the constraints on the new table

Example

AltEnableAddColnChk = NO