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