Re: Truncate === ????

Posted in 1998

Arun Shastry — Mon, 16 Nov 1998 10:52:16 -0500 — source: Informix-list mailing list archive (1991-1998)

Unfortunately Informix does not have an equivalent to TRUNCATE. The next best thing you can do is drop table followed by create table. Sorry... Arun T.Suresh Kumar wrote: > Hi > I want to delete all the records from a table with a command that is > similar to TRUNCATE table tablename option in ORACLE. > > Can any one give me how can I delete records from table very fast > without using DELETE statement? > > Suresh