Chapter 3 DBMS Reference Guide
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. |