Can I get more than one FK referencing the same PK?

Asked

Viewed 122 times

1

I wonder if it is possible to reference foreign keys (FK) from different tables to the same primary key (PK). Below is a piece of the SQL command

CREATE TABLE Run(
Project_Code INT FOREIGN KEY REFERENCES Projects(Project_Code),
)

CREATE TABLE Sen(
Project_Code INT FOREIGN KEY REFERENCES Projects(Project_Code),
)
database sql-server foreign-key primary-key

1 answer

3


It is possible, yes. Perfectly normal and widely used.

Browser other questions tagged database sql-server foreign-key primary-key

You are not signed in. Login or sign up in order to post.