If a given table contains a disabled foreign key, Toad generates a DDL script , but with the FK enabled.
Given the table:
CREATE TABLE tA(
id INT, ParentId INT, CONSTRAINT PK_tA PRIMARY KEY CLUSTERED(id));
ALTER TABLE tA WITH NOCHECK ADD CONSTRAINT FK_Parent FOREIGN KEY (ParentId) REFERENCES tA(id) NOT FOR REPLICATION;
ALTER TABLE tA NOCHECK CONSTRAINT FK_Parent;
Here's the code generated by Toad for SQL Server 6.5 Trial:
Here's the code generated by SSMS. Pay attention to the last row!
