Home » SQL & PL/SQL » SQL & PL/SQL » How to Drop a particular column in a table.
How to Drop a particular column in a table. [message #239217] Mon, 21 May 2007 15:12 Go to next message
kartik.of
Messages: 11
Registered: October 2005
Location: hyderabad
Junior Member
Please tell me the query to drop the particular column in a table.

Thanks in advance.
Regards,
Kartik.
Re: How to Drop a particular column in a table. [message #239218 is a reply to message #239217] Mon, 21 May 2007 15:16 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
alter table abx drop column xyz;
Re: How to Drop a particular column in a table. [message #239335 is a reply to message #239217] Tue, 22 May 2007 01:14 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
"alter table xxx drop column yyy" takes a long time.
Better use "alter table xxx set unused column yyy" which is immediate and then later, when you have time, "alter table xxx drop unused columns".

Regards
Michel
Previous Topic: Last Analyzed from USER_INDEXES
Next Topic: HOW TO CURSOR OUT FROM A TEMP TABLE
Goto Forum:
  


Current Time: Sat Dec 03 14:18:22 CST 2016

Total time taken to generate the page: 0.09681 seconds