TRUNCATE statement for Informix exists?

Posted in 1997

Jean-Francois DENIS — Mon, 22 Dec 1997 14:17:11 +0100 — source: Informix-list mailing list archive (1991-1998)

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