Chapter 3 DBMS Reference Guide


Variables for columns

Parent Table variables are also available.

Variable name 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 NullRequired

 


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