Re: anything like MS-SQL

Personally, I don't think "truncate" as a best practice... but: 1. As trucate is a delete without logging, why don't you consider using raw tables (ie no loggin), but you have to have the drawbacks of raw tables. 2. Drop the table, and then recreate it... you will need to have the schema first. 4. No other alternative comes to me right now, but why don't you propose to IBM-Informix a "truncate" function. Online 5 practically hasn't any usefull function... but some good ones where incorporated in IDS. Chucho! -----Original Message----- From: emebohw@netscape.net (sumGirl) To: informix-list@iiug.org Date: 16 Aug 2004 09:07:30 -0700 Subject: anything like MS-SQL "truncate" function in Informix? Is there something in Informix thats analagous to the truncate function in MSSQL Server truncate? Looking for a way to very quickly get rid of every row in a table. We have been dropping and recreating on the fly, but that has our programmers hard coding dbspaces into there apps which is probably not best practice. Jean Sagi jeansagi@myrealbox.com jeansagi@yahoo.com sending to informix-list