CODEWITHSUNDEEP
sqlsql-serverforeign-keys
Dawood Awan
Dawood Awan

Reputation: 7328

Sql foreign key constraint

I have a table with two FK from same table. I have following query:

I am attaching an Image: please let me know the error.

enter image description here

Upvotes: 4

Views: 2650

Answers (2)

Joe Taras
Joe Taras

Reputation: 15379

if you have created table Teams and Fixtures in the same session, Intellisense must be refreshed. If you have SQL error tell me and post your error.

P.S. use comma between two constraint rows

Upvotes: 2

Robert
Robert

Reputation: 25753

You have to put , char after 8th line as below

REFERENCES Teams(TeamID),

Upvotes: 2

Related Questions