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
-
“Foreign Key Definitions” in this book
-
“Using Foreign Keys” in Using Caché Objects
-
“Introduction to Compiler Keywords” in Using Caché Objects
