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


More information about the thelist mailing list