On Friday 09 September 2005 09:22, Rick Hillegas wrote: > Derby does have a RENAME TABLE command. > > Cheers, > -Rick > Perfect.
If you were to enhance the Alter Table to allow for a DROP COLUMN foo, then you'd rename the existing table to a temp name, rebuild the table with all of the columns except the one that you're dropping, add all the constraints and indexes... then reload the new table and drop the temp. Of course I'm probably missing something.... -- Michael Segel Principal MSCC (312) 952-8175
