Thursday 4 August 2016

and new column and foregin key in sql


ALTER TABLE Employee ADD JobTitleId INT NULL

ALTER TABLE [dbo].Employee
ADD CONSTRAINT [FK_Employee _JobTitle]
FOREIGN KEY (JobTitleId)
 REFERENCES [dbo].JobTitle (JobTitleId)