Forum Discussion

Copper Contributor

Feb 04, 2024

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(Tab...

azure storage

Kidd_Ip

MVP

Dec 10, 2025

Yes, this is valid and enforces one-to-one relationships. Ford one-to-many:

CREATE TABLE Table2 (
    Table2ID INT PRIMARY KEY,
    Table1ID INT,
    Column2 INT,
    FOREIGN KEY (Table1ID) REFERENCES Table1(Table1ID)
);