Skip to main content

SqlName (Index Keyword)

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:

  • name is the name of the index. It is useful to follow a naming convention so that indexes can be easily distinguished from properties. For example, you could include IDX at the end of all index names.

  • property_expression_list is either a single property name or a comma-separated list of properties, enclosed in parentheses.

  • 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 tab