Does anyone have insight into how the "import" would compare to the
"drop/recreate" workaround, performance-wise? I'm currently using
drop/recreate for a large number of tables, so just wondering if it would be
worth trying import.
Regarding holding up the truncate feature because of lack of sta
Amir Michail wrote:
On Feb 19, 2008 1:25 PM, Bryan Pendleton <[EMAIL PROTECTED]> wrote:
Is there a way to easily move a column from one table to another (as
easy as a rename say)?
alter table newtable add column newcolumn whatever-data-type;
update newtable set newcolumn = (value that
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.executeUpda