Chapter 3 DBMS Reference Guide

AddColnChck

Statement for modifying a column check in an alter table statement. This statement is used in the database modification script when the check parameters of a column have been modified in the table.

AltEnableAddColnChk must be set to YES to allow use of this statement.

If AddColnChck is empty, 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 check parameter modification
• Inserts the rows from the old table to the new temporary table
• Drops the actual table
• Creates a new table with the check parameters for the column
• Inserts the rows from the temporary table to the new table
• Creates the indexes and the constraints on the new table

Example

In Sybase Adaptive Server Anywhere 6:

AddColnChck = alter table [%QUALIFIER%]%TABLE%
modify %COLUMN%  [default %DEFAULT%]
[check (%CONSTRAINT%)]

The %COLUMN% variable is the name of the column defined in the table property sheet. The % CONSTRAINT % variable is the check constraint built from the new check parameters.

See also AltEnableAddColnChk .

Copyright (C) 2005. Sybase Inc. All rights reserved.