Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Need help to create table on given Data model diagram RE: Need help to create table on given Data model diagram

  • July 27, 2015 at 1:41 am

    #1815044

    Create the table as usual, then add the FKs using ALTER TABLE:

    alter table MyTable

    add constraint MyTable_MyColumn_FK FOREIGN KEY ( MyColumn ) references MyOtherTable(PKColumn)