Re: Emptying Tables

Posted in 1998

bala peddi — Tue, 17 Mar 1998 16:33:37 -0500 — source: Informix-list mailing list archive (1991-1998)

No , ,,,,, BTW Informix Delete is Much faster than Ingres initialize. BALA 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. > ------------------------------------------------------------------------- > Herb Blacker > Cimarron, Inc. > Database Administrator - DOL Job Corps San Marcos, Texas > ------------------------------------------------------------------------