[thelist] MSSQL: Deleting rows with circular FK constraints

[Tab Alleman]

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?