Home » RDBMS Server » Server Administration » ALTER TABLE DROP COLUMN does not work correctly
ALTER TABLE DROP COLUMN does not work correctly [message #371032] Tue, 15 August 2000 10:44 Go to next message
FrankPacher
Messages: 2
Registered: August 2000
Junior Member
The statemant ALTER TABLE <..> DROP COLUMN <...> does not work.
Who can help ?
(I must delete a column from a table)

Thanks
Frank FrankPacher@gmx.de
Re: ALTER TABLE DROP COLUMN does not work correctly [message #371037 is a reply to message #371032] Tue, 15 August 2000 14:46 Go to previous messageGo to next message
Lee
Messages: 56
Registered: May 1999
Member
Are you using Oracle 8i?

You can create a new table with one less col and then rename it.
Re: ALTER TABLE DROP COLUMN does not work correctly [message #371044 is a reply to message #371032] Wed, 16 August 2000 15:25 Go to previous message
Ahuja
Messages: 3
Registered: August 2000
Junior Member
It works fine for me.
Pls. explain in detail what problem you are facing ?

Thanks
Previous Topic: Complex Join
Next Topic: REF CURSOR parameter
Goto Forum:
  


Current Time: Sat Oct 31 20:43:30 CDT 2020