1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

How To drop Multiple columns in a table in single query

Discussion in 'SQL PL/SQL' started by RajeshIr, Jan 24, 2015.

  1. RajeshIr

    RajeshIr Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Dear all
    How to delete the multiple columns in a table using single query
     
  2. rajenb

    rajenb Forum Expert

    Messages:
    361
    Likes Received:
    114
    Trophy Points:
    655
    Location:
    Mauritius
    You can use the following SQL statement:

    ALTER TABLE <tablename> DROP (<ColumnName1>, <ColumnName2>, ... , <ColumnNamex>);
     
  3. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    626
    Likes Received:
    129
    Trophy Points:
    810
    Location:
    Russian Federation