RE: Quick way to delete data from Informix

Posted in 1999

Daniel Bonesana — Tue, 9 Nov 1999 16:05:42 -0300 — source: Informix-list mailing list archive (1991-1998)

dbschema your database drop database create database using the later saved schema > N. Daniel Bonesana > SIEMENS-ITRON BUSINESS SERVICES S.A. > Balcarce 683, (C1064AAM) Buenos Aires, Argentina. > * 54 (11) 4320-5456 * dbones@siemens-itron.com.ar > > -----Original Message----- From: Harry Sheng [mailto:hsheng@crosskeys.com] Sent: Tuesday, November 09, 1999 12:30 PM To: informix-list@iiug.org Subject: Quick way to delete data from Informix Hello, I want to clean all the data from a database (IDS7.3) but I want to keep all the table schemas not to be deleted. Is there anyone know a low cost, quick way to do this? I know ORACLE has a low cost "TRUNCATE TABLE" that can be used for this purpose, I do not know if INFORMIX also provide similiar or even better solution. Any idea will be greatly appreciated.