-
How can I drop multiple columns from a table in a single command
Oracle says there is a 'continue' option in 'Alter table drop column '
But I don't know how to use that option . I am trying various combinations but it's not working.
Amol
-
"ALTER TABLE DROP COLUMNS CONTINUE" is used to complete dropping the column before accessing the table.
I really don't know if you can drop 2 columns at the same time. It is really not that important feature. Run the command two times and you will drop the columns :-)
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
ALTER TABLE tablename DROP ( column1, column2, ... ) might be what your looking for.
Andy
-
ALTER TABLE table_name SET UNUSED (column_name1, column_name2);
ALTER TABLE table_name DROP UNUSED COLUMNS;
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|