Re: Truncate Table and Indexes
From: maceyah <maceyah_at_yahoo.com>
Date: 14 Aug 2001 13:40:53 -0700
Message-ID: <9444efbd.0108141240.5464a306_at_posting.google.com>
Date: 14 Aug 2001 13:40:53 -0700
Message-ID: <9444efbd.0108141240.5464a306_at_posting.google.com>
I think you could have problems with the order based on Referential
Integrity. Either disable all the RI effected or truncate from the
child tables upwards.
Dropping the index first won't help. The index also gets truncated
when you truncate the table. Only drop it if you don't want it there
during reloading of the tables. Truncate has two options you should
consider i.e. drop/reuse storage.
Received on Tue Aug 14 2001 - 22:40:53 CEST