>
>Can you temporarily drop with contraint with
>
>ALTER TABLE Tablename NOCHECK CONSTRAINT ConstraintName
>
>then reestablish with
>
>ALTER TABLE Tablename CHECK CONSTRAINT ConstraintName
I'll give that a shot if I need to. I downloaded a script that when run on a database, returns the table heirarchy based on defined constraints. If I truncate tables based on this order - I'm hoping that I can leave the constraints alone.
Al Williams
Anola MB, CANADA