Answers for "can we change the type of foreign key in sql server"

alter foreign key

ALTER TABLE Employee
ADD FOREIGN KEY (DeptNo) REFERENCES Department(DeptNo);

Posted by: Guest on July-06-2021

SQL Server rename foreign key constraint

sp_rename 'schema_name.old_fk_name', 'new_fk_name';

Posted by: Guest on November-09-2021

Code answers related to "can we change the type of foreign key in sql server"