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.
