3
Reply

Can you drop all the columns of a table ?

Deepak Verma

Deepak Verma

13y
5.3k
0
Reply

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


    i think it will not possible..


    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