db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From fancellu <d...@felstar.com>
Subject Re: Any ETA on "truncate table" ?
Date Wed, 20 Feb 2008 09:57:06 GMT

Unfortunately I don't have the free time to help the project, I have enough
of my own fish to fry.

However, as a work around, I've found it much quicker to simply drop the
table and then recreate it with the same name.

e.g.

        Statement stat=conn.createStatement();
        stat.executeUpdate("DROP TABLE PKS");
        stat.executeUpdate("CREATE TABLE PKS ( PK varchar(32) PRIMARY KEY
NOT NULL )" );
        conn.commit();

-- 
View this message in context: http://www.nabble.com/Any-ETA-on-%22truncate-table%22---tp15562346p15585747.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.


Mime
View raw message