I think its not possible. SQL Management Object (Smo) requires at least one data column in a table.
Loading
Can you drop all the columns of a table ?
3 Answers
Vilas GitePosted May 6, 2011, 5:50 AM
i think it will not possible..
Shirsendu NandiPosted May 4, 2011, 1:28 AM
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
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
Jiteendra SampathiraoPosted May 3, 2011, 8:46 AM