Re: Emptying Tables

Posted in 1998

Bryan Tonnet — 19 Mar 1998 21:14:29 +1100 — source: Informix-list mailing list archive (1991-1998)

In <3510DD8E.9CF366BB@pacbell.net> Robert Read <rread@pacbell.net> writes: >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. You could let my 2 year old play with your database. He's also good at switching off servers, and unplugging ethernet hubs, if it's any help :) -- Bryan Tonnet batonnet@phase4.com.au