Some sample statements to get you started:
ALTER TABLE Department ADD CONSTRAINT pk_Department PRIMARY KEY(DeptId)
ALTER TABLE Supervisor ADD
CONSTRAINT fk_Supervisor_Department
FOREIGN KEY (DeptID) REFERENCES (DeptID)
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I have three tables at SQL SERVER 2019 described below:
Table DEPARTMENTS : Columns DeptID , DeptName example FINANCE, IT .
Table EMPLOYEE : Columns : employeeID , SupervisorID .
Table SUPERVISOR : Columns : FirstName, LastName, SupervisorID, DeptID .
HOW TO EXECUTE ON QUERY in SQL SYNTAX OF PRIMARY KEYS AND FOREIGN KEYS FOR THESE THREE TABLES???
THANK YOU DEAREST FRIENDS . YOUNG KOSOVAR CITIZEN FROM KOSOVO ..
Some sample statements to get you started:
ALTER TABLE Department ADD CONSTRAINT pk_Department PRIMARY KEY(DeptId)
ALTER TABLE Supervisor ADD
CONSTRAINT fk_Supervisor_Department
FOREIGN KEY (DeptID) REFERENCES (DeptID)