Skip to main content

This is documentation for Caché & Ensemble.

For information on converting 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 foreign key.

Usage

To override the default SQL name for this foreign key, use the following syntax:

ForeignKey keyname(key_props) References pkg.class(ref_index) [ SqlName = alternate_name ];

Where alternate_name is an SQL identifier.

Details

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

Default

If you omit this keyword, the SQL name for the foreign key is keyname as specified in the foreign key definition.

See Also

FeedbackOpens in a new window