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]

)

 



© 2018 | Анна Петросян | pashelp@yandex.ru