Can you drop all the columns of a table ?
Deepak Verma
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