Chapter 3 DBMS Reference Guide

ModifyColnDflt

Statement for modifying a column default value in an alter table statement. This parameter is used in the database modification script when the default value of a column has been modified in the table.

If ModifyColnDflt 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 default value modification
• Inserts the rows from the old table to the new temporary table
• Drops the actual table
• Creates a new table with the new default value for the modified 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:

ModifyColnDflt = alter table [%QUALIFIER%]%TABLE%
modify %COLUMN% default %DEFAULT%

The %COLUMN% variable is the name of the column defined in the table property sheet. The %DEFAULT% variable is the new default value of the modified column.

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