Friday, May 6, 2011

Create Foreign Key SQL

How do I create a foreign key

from table tGeoAnswers column 'locationId'

to table tLocations column 'id'?

ALTER TABLE 
        tGeoAnswers 
ADD 
        FK_Answer_Location 
FOREIGN KEY 
        (locationId)
REFERENCES 
        tLocations(id)

I am trying this code that I found but I get the following error:

The definition for column 'FK_Answer_Location' must include a data type

From stackoverflow
  • ALTER TABLE tGeoAnswers ADD CONSTRAINT FK_Answer_Location ...
    

    Otherwise it assumes you're adding a column called FK_Answer_Location.

  • Please have a look at the bottom of http://www.1keydata.com/sql/sql-foreign-key.html about the ALTER TABLE ADD ... FOREIGN KEY syntax.

  • Assuming MsSql Server/T-SQL, use ALTER TABLE:

     ALTER TABLE tGeoAnswers
     ADD CONSTRAINT FK_Answer_Location
     FOREIGN KEY (LocationId) REFERENCES tLocation (Id)
    

0 comments:

Post a Comment