Forum Discussion

DynamicsHulk's avatar
DynamicsHulk
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(Table1ID) 
);

 

CREATE TABLE Table3(

    PRIMARY KEY (Table1ID), 
    Column2 int,

   FOREIGN KEY (Table1ID) REFERENCES Table1(Table1ID) 
);

 

 

 

 

azure storage

1 Reply

  • Kidd_Ip's avatar
    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)
);

     

Resources