I have the following FK on Items table
ALTER TABLE [dbo].[items] WITH NOCHECK ADD CONSTRAINT [FK_items_i_tmpnam] FOREIGN KEY([i_tmpnm_id])
REFERENCES [dbo].[i_tmpnam] ([tmpnam_id])
NOT FOR REPLICATION
Yet I'm able to delete all records from i_tmpnam and leave orphans in the FK field in the Items table. So, does NOCHECK disables the constraint completely?
Premature optimization is the root of all evil in programming.
(c) by Donald Knuth
Naomi Nosonovsky, Sr. Programmer-Analyst
View Complete Post