As we transition our database, I'm finding the need to change columns types. I'm also finding this to be a major PITA.
I have a column that's a something like: create table stuff ( ... rate varchar(7), ... ); However that doesn't allow math-like functions (e.g. avg), so it's gotta be changed. I'd like to do something on the order of: alter table stuff modify rate DECIMAL(5,2); but that doesn't work. I've scoured the docs and can't seem to find anything other than: 1. create new table with changed columns, 2. copy data over, 3. remove old table, 4. rename new table to old table Please tell me there's an easier way! And of course how. :-) Also, I can't find a "alter table drop column NAME" to remove a column either. TIA, Kevin ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
