dropping multiple columns from a single command
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: dropping multiple columns from a single command

  1. #1
    Join Date
    Dec 2000
    Posts
    255
    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

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    "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
    email: ocp_9i@yahoo.com

  3. #3
    Join Date
    Apr 2002
    Posts
    14
    ALTER TABLE tablename DROP ( column1, column2, ... ) might be what your looking for.

    Andy

  4. #4
    Join Date
    May 2011
    Posts
    1
    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
  •  



Click Here to Expand Forum to Full Width