CREATE TABLE main table (
ID1 Int Not Null,
ID2 INT NOT NULL,
Name varchar (10),
ConsTRAINT PK_ Monthly Table PRIMARY Key (ID1, Id2)
)
CREATE TABLE from the table
ID Int IDENTITY (1, 1) Primary Key,
A_ID1 INT NOT NULL,
A_ID2 INT NOT NULL,
Word varchar (10),
ConsTRAINT FK_ from the table _ primarian Foreign Key (A_ID1, A_ID2)
References main table (ID1, ID2) on Update Cascade on delete cascade
Go
