Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

column deletion using Sql statement

665704Oct 17 2008 — edited Oct 18 2008
sir

I am a databsse user.
i would like to post one question that i often fall in prey.

i want to delete a column from a table and i am using the following statement:

Alter Table Tablename drop column Columnname;

But this does not work at all.
I am using Oracle 8.

Please suggest me how to do the job.


Rayees
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 15 2008
Added on Oct 17 2008
24 comments
1,355 views