Home » RDBMS Server » Server Administration » delete a column from a table
delete a column from a table [message #374509] Fri, 15 June 2001 10:45 Go to next message
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jul 06 01:21:44 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.