InterSystems IRIS Data Platform 2019.2  /  Class Definition Reference  /  Foreign Key Keywords

Class Definition Reference
Previous section          
InterSystems: The power behind what matters   

Specifies an SQL alias for the foreign key.
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.
This keyword lets you define an alternate name for this foreign key when referred to via SQL.
If you omit this keyword, the SQL name for the foreign key is keyname as specified in the foreign key definition.
See Also

Previous section          
Send us comments on this page
View this book as PDF   |  Download all PDFs
Copyright © 1997-2019 InterSystems Corporation, Cambridge, MA
Content Date/Time: 2019-09-19 06:56:35