Chapter 3 DBMS Reference Guide


Variables for columns

Parent Table variables are also available.

Variable Comment
%COLUMN% Generated code of Column
%COLNNO% Position of Column in List of columns of Table
%COLNNAME% Name of Column
%COLNCODE% Code of Column
%PRIMARY% Contains Keyword "primary" if Column is primary key column
%ISPKEY% TRUE if Column is part of Primary key
%FOREIGN% TRUE if Column is part of one foreign key
%COMPUTE% Compute constraint text
%NULLNOTNULL% Mandatory status of a column. This variable is always used with NullRequired item, see Working with Null values

 


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