Forum Discussion
DynamicsHulk
Feb 04, 2024Copper Contributor
Azure SQL Database : Can I use same primary key column and foreign key column for multiple tables?
CREATE TABLE Table1(
PRIMARY KEY (Table1ID),
Column2 int
);
CREATE TABLE Table2(
PRIMARY KEY (Table1ID),
Column2 int,
FOREIGN KEY (Table1ID) REFERENCES Table1(Table1ID)
);
CREATE TABLE Table3(
PRIMARY KEY (Table1ID),
Column2 int,
FOREIGN KEY (Table1ID) REFERENCES Table1(Table1ID)
);
No RepliesBe the first to reply