Member Avatar for Sravani saka

how to drop multiple columns at a time.. i tried with the following syntax "alter table <table_name> drop column <col_name1>, <col_name2>" but i am getting syntactical error.

  • 2 Contributors
  • 5 Replies
  • 274 Views
  • 23 Hours Discussion Span
  • Latest Post Latest Post by Sravani saka
Member Avatar for akmozo

Hi,

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

alter table <table_name> drop <col_name1>, <col_name2>
Edited by akmozo
Member Avatar for Sravani saka

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 "

Member Avatar for akmozo

Hi again,

Sorry, I thought that you are speaking about mysql.

Try this with oracle :

alter table
   sample
drop
   (empno, ename);
Edited by akmozo
Member Avatar for Sravani saka

oh.. its ok.. i'l try and let u know.. thanq so much..

Member Avatar for Sravani saka

hey thanq akmozo.. it is working :)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.