This is something I have been wanting for a long time. The ability to
update or drop a column from a table.
Right now you have to select the columns you want into a temp table and
drop the working table and rename the temp table to the working table.
|On 020123 12:15
|Jodi Kanter (jkanter@virginia.edu) wrote the following...
|
|I cannot seem to locate any documentation about removing a column that I just added to a table. There is no data in
thatparticular column but there is in the rest of the table.
|Can I remove this column or will I need to drop the entire table and restore from backup?
|Thanks
|Jodi
|_______________________________
|Jodi L Kanter
|BioInformatics Database Administrator
|University of Virginia
|(434) 924-2846
|jkanter@virginia.edu
--
BOFH Reason of the day: not properly grounded, please bury computer
_ | _
(_()(|('.|)('||.|()|`|(