Skip to main content

This is documentation for Caché & Ensemble.

For information on converting to InterSystems IRIS, see the InterSystems IRIS Adoption Guide and the InterSystems IRIS In-Place Conversion Guide, both available on the WRC Distributions page (login required).

Previous sectionNext section


Specifies an SQL alias for the index.


To override the default name for this index when referred to via SQL, use the following syntax:

Index name On property_expression_list [ SqlName = sqlindexname];

Where sqlindexname is an SQL identifier.


This keyword lets you define an alternate name for this index when referred to via SQL.


If you omit this keyword, the SQL name of the index is indexname as given in the index definition.

See Also