cascade constraints on drop table, also on delete or truncate?

I understand you can drop a table, with cascade constraints.

Can you do this when deleting rows? How about when truncating a table (ideal)?

I am trying to figure out the fastest way to purge a schema of all data, in order to reload it. We dont want to drop/recreate, we would rather do a truncate of the tables. Are we going to have to disable or delete the constraints first? If so that is hard to do in a script because the names of the constraints are machine generated on create time.

Any ideas?

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat May 27 2000 - 00:00:00 CDT