Deepak Verma
Can you drop all the columns of a table ?
By Deepak Verma in Databases & DBA on May 02 2011
  • Vilas Gite
    May, 2011 6

    I think its not possible. SQL Management Object (Smo) requires at least one data column in a table.   


    • 0
  • Shirsendu Nandi
    May, 2011 4

    i think it will not possible..

    • 0
  • Jiteendra Sampathirao
    May, 2011 3


    No, you can't drop all the columns of a table. one data column must be available in the table.
    To drop all the columns you have to drop the entire table.
    To Drop columns one at a time, you can use the below syntax.
    ALTER TABLE table_name DROP COLUMN column_name

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS