Chapter 3 DBMS Reference Guide
| Variable | 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) 2007. Sybase Inc. All rights reserved. |
| |