Re: TRUNCATE statement for Informix exists?

Posted in 1997

Glen Bayliss — Tue, 23 Dec 1997 13:31:48 +1100 — source: Informix-list mailing list archive (1991-1998)

Jean-Francois DENIS wrote: > > Hello, > > With Oracle, you can use the statement TRUNCATE that deletes logically > all records of a table (while the table definition and indexes remain). > This is much more performant than DROP/CREATE statements since it is a > logical delete. > Does anyone know if a similar statement exists in Informix? > Thanks for your help. > Jean-Francois > -- > ********************************************** > * Jean-Francois DENIS * > * Siemens Nixdorf Belgium * > * e-mail: jean-francois.denis@s1.bru1.sni.be * > ********************************************** Why don't you try DELETE FROM tablename WHERE 1=1