[thelist] MSSQL: Deleting rows with circular FK constraints

Joshua Olson joshua at waetech.com
Mon Sep 22 10:12:36 CDT 2003

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

Thanks in advance.

Joshua Olson
Web Application Engineer
WAE Tech Inc.

More information about the thelist mailing list