Re: Emptying Tables

Posted in 1998

david.ashby@workcover.nsw.gov.au — Wed, 18 Mar 98 10:27:43 +1000 — source: Informix-list mailing list archive (1991-1998)

Herb, I assume you are talking about the "modify to truncate command". There is no equivalent Informix command. The best way is to drop and recreate. Regards David Ashby ______________________________ Reply Separator _________________________________ Subject: Emptying Tables Author: Herb Blacker <herbb@jcdcrs4.jobcorps.org> at WCA-INET Date: 17/3/98 1:52 PM 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 ------------------------------------------------------------------------