T-SQL | ADD RELATIONAL CONSTRAINTS |
Один первичный ключ:
ALTER TABLE [DBO].[CHILDTABLENAME] ADD CONSTRAINT [FK_CHILDTABLENAME_PARENTTABLENAME1] FOREIGN KEY ( [FIELDNAME1] ) REFERENCES [DBO].[PARENTTABLENAME1] ( [FIELDNAME1] )
Два первичных ключа:
ALTER TABLE [DBO].[CHILDTABLENAME] ADD CONSTRAINT [FK_CHILDTABLENAME_PARENTTABLENAME1] FOREIGN KEY ( [FIELDNAME1] ) REFERENCES [DBO].[PARENTTABLENAME1] ( [FIELDNAME1] ), CONSTRAINT [FK_CHILDTABLENAME_PARENTTABLENAME2] FOREIGN KEY ( [FIELDNAME2] ) REFERENCES [DBO].[PARENTTABLENAME2] ( [FIELDNAME2] )
|