Add Foreing Key to multiple Tables in SQL Server

Hi rajeesh,

You can create foreign key to multiple table.

Refer below query to add Foreign Key column.

SQL

-- Add Foreign Key to Table2 from Primary Key of Table1
ALTER TABLE Table2
ADD CONSTRAINT FK_Table2_Table1 FOREIGN KEY (Table2ID) REFERENCES Table1 (Table1ID);
Go
-- Add Foreign Key to Table3 from Primary Key of Table1
ALTER TABLE Table3
ADD CONSTRAINT FK_Table3_Table1 FOREIGN KEY (Table3ID) REFERENCES Table1 (Table1ID);

For more details refer below link.

Create Foreign Key Relationships