Re: Emptying Tables

Herb Blacker wrote: > Is there an easy way to quickly empty a table, other than either > "delete from xxx where 1=1;" or dropping the table and recreating it? > I'm an old Ingres DBA, and there used to be an 'initialize' SQL > command to quickly empty a table. A compromise solution might be to drop the indexes and then delete and then recreate the indexes, but I guess that wouldn't be very easy unless you wrote a script to do it, and it would still be faster to just drop the table. If you do drop the table, then don't forget to specify the extent size when you recreate it.