RE: Quick way to delete data from Informix

You can run dbschema to export the structure, drop database and re-create using the schema file. > ---------- > From: Harry Sheng[SMTP:hsheng@crosskeys.com] > Reply To: Harry Sheng > Sent: Tuesday, November 09, 1999 1:29 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. >