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

Report message to a moderator

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.

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Sep 29 17:08:36 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.