Chapter 3 DBMS Resource File Reference


Variables for reference columns

Variable Comment
%CKEYCOLUMN% Generated code of Parent table column (primary key)
%FKEYCOLUMN% Generated code of Child table column (foreign key)
%PK% Generated code of Primary key column
%PKNAME% Primary key column name
%FK% Generated code of Foreign key column
%FKNAME% Foreign key column name
%AK% Alternate key column code (same as PK)
%AKNAME% Alternate key column name (same as PKNAME)
%COLTYPE% Primary key column data type
%DEFAULT% Foreign key column default value
%HOSTCOLTYPE% Primary key column data type used in procedure declaration. For example: without length

 


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