#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Posts
    36
    Rep Power
    15
    Is it possible to drop more than one column from a table. There are whole bunch I want to drop but I can't figure out the syntax.

    I tried:
    ALTER TABLE trials DROP (var1, var2);

    and
    Alter Table trials DROP var1, var2;

    and alter table trials drop var1 var2;

  2. #2
  3. No Profile Picture
    RyanP
    Guest
    Devshed Newbie (0 - 499 posts)
    in the manual

    use multiple drop statements

    ALTER TABLE trials
    DROP var1,
    DROP var2;

Similar Threads

  1. Search and Results using multiple columns
    By dylan2004 in forum MS SQL Development
    Replies: 2
    Last Post: February 11th, 2004, 10:24 AM
  2. using multiple columns in one index
    By bakedbean in forum MySQL Help
    Replies: 3
    Last Post: November 6th, 2003, 10:30 AM
  3. Displaying database records over multiple columns
    By SnowCrash in forum PHP Development
    Replies: 4
    Last Post: September 25th, 2003, 07:50 AM
  4. Sorting DB entries over multiple pages (and columns)
    By Milktray in forum PHP Development
    Replies: 2
    Last Post: August 7th, 2003, 09:17 AM
  5. Multiple columns? (how to query)
    By Kinsbane in forum MySQL Help
    Replies: 8
    Last Post: July 11th, 2003, 01:04 PM

IMN logo majestic logo threadwatch logo seochat tools logo