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
Comments
Post a Comment