ASP DOT NET

Tuesday, November 27, 2018

How to Alter "FOREIGN KEY" in existing table?

Ans.


ALTER TABLE [dbo].[Table2]  WITH CHECK ADD FOREIGN KEY([Dept_Id])
REFERENCES [dbo].[Table1] ([Dept_Id])

No comments:

Post a Comment

How to to select duplicate rows from sql server?

 SELECT * FROM Recruitment WHERE Email IN (SELECT Email FROM Recruitment GROUP BY Email HAVING COUNT(*) > 1); WITH CTE AS (     SELECT   ...