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.
Sravani saka
0
Newbie Poster
Recommended Answers
Jump to PostHi,
This is the correct manner ( without column after drop):
alter table <table_name> drop <col_name1>, <col_name2>
Jump to PostHi again,
Sorry, I thought that you are speaking about mysql.
Try this with oracle :
alter table sample drop (empno, ename);
All 5 Replies
akmozo
5
Light Poster
Sravani saka
0
Newbie Poster
akmozo
5
Light Poster
Sravani saka
0
Newbie Poster
Sravani saka
0
Newbie Poster
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.