Emptying Tables

Posted in 1998

Herb Blacker — Tue, 17 Mar 1998 13:52:43 -0600 (CST) — source: Informix-list mailing list archive (1991-1998)

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 ------------------------------------------------------------------------