[thelist] MSSQL: Deleting rows with circular FK constraints
Tab Alleman
Tab.Alleman at MetroGuide.com
Mon Sep 22 14:46:11 CDT 2003
Joshua Olson wrote:
> Hi listees,
>
> I inherited a db structure with circular COLUMN REFERENCE
> constraints. I'm trying to purge data with either TRUNCATE TABLE or
> DELETE FROM, but the database won't let me because of the
> constraints. Other that dropping and rebuilding the constraints, is
> there any way to purge the data from the tables?
>
DELETE WITH NOCHECK?
More information about the thelist
mailing list