3
Reply

Can you drop all the columns of a table ?

Deepak Verma

Deepak Verma

May 02, 2011
5.2k
0

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


    Vilas Gite
    May 06, 2011
    0

    i think it will not possible..

    Shirsendu Nandi
    May 04, 2011
    0


    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