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) 2006. Sybase Inc. All rights reserved. |
| |