Skip to main content

This is documentation for Caché & Ensemble. See the InterSystems IRIS version of this content.Opens in a new window

For information on migrating to InterSystems IRISOpens in a new window, see the InterSystems IRIS Migration Guide and Migrating to InterSystems IRIS, both available on the WRC Distributions pageOpens in a new window (login required).

SqlName

Specifies an SQL alias for the index.

Usage

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.

Details

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

Default

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

See Also

FeedbackOpens in a new window