Saturday 14 May 2016

How to create foreign key in sql

Order table(ord_Id int NOT NULL,OrderNo int NOT NULL,Client_Id int,PRIMARY KEY (ord_Id),CONSTRAINT fk_ClientOrder FOREIGN KEY (Client_Id)REFERENCES Client(Client_Id))