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) 
);

 

 

 

 

No RepliesBe the first to reply

Resources