Warning: Undefined array key "HTTP_REFERER" in /home/u522501990/domains/makemeengr.com/public_html/wp-content/themes/generatepress/generatepress.theme#archive on line 43

How do I create a foreign key in SQL Server?

And if you just want to create the constraint on its own, you can use ALTER TABLE

alter table MyTable
add constraint MyTable_MyColumn_FK FOREIGN KEY ( MyColumn ) references MyOtherTable(PKColumn)

I wouldn’t recommend the syntax mentioned by Sara Chipps for inline creation, just because I would rather name my own constraints.

Leave a Comment

techhipbettruvabetnorabahisbahis forumutaraftarium24eduedueduseduedusedueduedusedusedus