[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
tables?

Thanks in advance.

<><><><><><><><><><>
Joshua Olson
Web Application Engineer
WAE Tech Inc.
http://www.waetech.com
706.210.0168



More information about the thelist mailing list