Chapter 3 DBMS Reference Guide


AddColnCheck

Statement for customizing the script for modifying column constraints within an alter table statement.

Example

In Oracle 9i:

alter table [%QUALIFIER%]%TABLE%
   modify (%COLUMN%  %DATATYPE%  constraint %CONSTNAME% check (%CONSTRAINT%));

 


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