user61614
0
Q:

delete foreign key sql

USE AdventureWorks2012;  
GO  
ALTER TABLE dbo.DocExe   
DROP CONSTRAINT FK_Column_B;   
GO  
2

ALTER TABLE Orders

DROP CONSTRAINT FK_PersonOrder; 
0

ALTER TABLE Orders

ADD CONSTRAINT FK_PersonOrder

FOREIGN KEY (PersonID)
REFERENCES Persons(PersonID); 
0

New to Communities?

Join the community