Chapter 3 DBMS Reference Guide


Variables for indexes

Variable name Comment
INDEX Generated code of Index
TABLE Generated code of the parent of an index, can be a table or a query table (view)
INDEXNAME Index name
INDEXCODE Index code
UNIQUE Contains Keyword "unique" when Index is unique
INDEXTYPE Contains Index type (available only for a few DBMS)
CIDXLIST List of index columns with separator, on the same line. Example: A asc, B desc, C asc
INDEXKEY Contains Keywords "primary", "unique" or "foreign" depending on Index origin
CLUSTER Contains Keyword "cluster" when Index is cluster
INDXDEFN Used for defining an index within a table definition

 


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