Thread: help??? Now I can't drop a renamed column....

Ok, ok...

I'm beginning to see some limitations here.

Can't MODIFY a column name. as in

ALTER TABLE tablename MODIFY existingColumnName CHAR( 24 );

So tried RENAME, and ADD COLUMN,

and ended up with ISBN and XSBN


fine. Now how do I get rid of XSBN.??????

Thanks for any pointers
Bob

---  http://4qir.quantum-radio.net.au - Where Only The Dedicated Survive!
4QIR Quantum Radio. Bringing you the original sounds of AFVN, with some of
the
original DJ's - back on air - and supporting not only the original Vets, in
comprehensive AFVN Archives, but putting together segments for the fighting
men and
women of todays services all around the world. World Music, for people of
the world.