OraFAQ Forum: Server Administration » delete a column from a table

Home » RDBMS Server » Server Administration » delete a column from a table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

delete a column from a table [message #374509]

Fri, 15 June 2001 10:45

arpan
Messages: 2
Registered: June 2001

Junior Member

hello
please tell me how to delete a column from a table

Report message to a moderator

Re: delete a column from a table [message #374519 is a reply to message #374509]

Fri, 15 June 2001 18:21

Andrew again...
Messages: 270
Registered: July 2000

Senior Member

in Oracle 8.1.5

atler table XYZ drop column ABC.

In earlier releases, create a new table with the right structure, populate it drop the old table (after disabling RI constraints)and rename the new to old. Remember to add constraints, indexes, comments, triggers etc and recompile stored code.

Report message to a moderator

Previous Topic:	Database name
Next Topic:	How to add new column to a already available table?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 11 01:56:37 CST 2025