Question

What MySQL returns when we remove all the columns from a table by using ALTER TABLE command with DROP keyword?

Answer 1

First, specify the table that contains the column you want to remove after the ALTER TABLE clause.

Second, put the name of the column following the DROP COLUMN clause.