Foreign key relationship with composite primary keys in SQL Server 2005

user_346348 0
Viewed 111058

I have two tables 

Table1(
  FileID,
  BundledFileID,
  Domain)

and 

Table2(
  FileID,
  FileType,
  FileName)

In Table2 FileID and FileType are the composite primary key. I want to create a foreign key relationship from Table1.FileID to Table2.

Is it possible to do this?

composite-primary-key foreign-key-relationship sql-server-2005
3 Answers

I did this using SQL Server Management Studio:

First reference foreign keys, then make composite primary key.

When you create Table2, don't make a primary key at all in the beginning. First create the foreign key of Table2.FileID with Table1.FileID. And then set the composite key for Table2 (Table2.FileID, Table2.FileType).

Same concept goes if FileType needs to be a foreign key as well. First reference both of the foreign keys and then create the composite key.

user_92386250
Related