Derby does have a RENAME TABLE command.
Cheers,
-Rick
Michael J. Segel wrote:
On Thursday 08 September 2005 20:09, [EMAIL PROTECTED] wrote:
Hi Susan,
Is there any other way we can drop columns
which are not objects you mentioned ?
or impossible ?
thanks,
Wolfgang
You could always do a simple work around.
I don't know if you can rename the table, you can always copythe data you want
of the table to a temp table. Drop the table, then recreate with the missing
column and reload.
Its sort of what the Alter Table would do...
