Skip to content
«
»
 

Add Foreign Key

Posted by 
on  July 26 2009

To Add a foreign key to a column in an existing table, use ALTER TABLE ADD CONSTRAINT

ALTER TABLE dbo.President_Lookup
ADD CONSTRAINT fk_PresidentID
FOREIGN KEY (PresidentID)
REFERENCES dbo.Presidents (PresidentID)


Popular search terms:
Filed under DDL
Comment (RSS)  |  Trackback  |  Permalink

2 Comments

  1. sanket says:
    November 19, 2011 at 9:35 pm

    I have 1 query.
    I have 2 tables, one is master and another is normal table.
    the primary key of one table is used in 2nd table…
    bt I dont know, how I can set that key will foreign..????
    please send mi feedback on my email…
    or give mi an example code for setting foreign key…

    Reply to this comment
  2. Anonymous says:
    June 21, 2011 at 2:58 am

    THIS IS NOT WORKING

    Reply to this comment

post a comment OR Post Your Question on our ASK! Community!

«
»