Chapter 3 DBMS Reference Guide

ModifyColumn

Statement for modifying a column. This parameter is used in the database modification script when the column definition has been modified. The ModifyColumn statement defined in this parameter is a specific SQL statement different from the alter table statement. It is not supported by all DBMS.

Example

In Sybase Adaptive Server Anywhere 6:

alter table [%QUALIFIER%]%TABLE%
modify %COLUMN% %DATATYPE% %NOTNULL%

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