ALTER TABLE Managers ADD FOREIGN KEY (Id) REFERENCES Organization(Id)
CREATE TABLE Orders ( O_Id int NOT NULL PRIMARY KEY, OrderNo int NOT NULL, P_Id int FOREIGN KEY REFERENCES Persons(P_Id) )
"P_Id"
"Persons"
"Orders"
ALTER TABLE ORDERS ADD FOREIGN KEY (customer_sid) REFERENCES CUSTOMER(SID);
Quote:Visit this link How to Create Primary and Foreign key[^]
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)