2
Contributors
5
Replies
8
Views
5 Years
Discussion Span
Last Post by Sravani saka
0

Hi,

This is the correct manner ( without column after drop):

alter table <table_name> drop <col_name1>, <col_name2>

Edited by akmozo

0

hi akmozo, i have tried to drop multiple columns using your syntax. but i am getting error, as missing keyword.. the query is as below
" alter table sample drop empno,ename "

0

Hi again,

Sorry, I thought that you are speaking about mysql.

Try this with oracle :

alter table
   sample
drop
   (empno, ename);

Edited by akmozo

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.