Home » mysql » Drop command to remove a column from a table.

Drop command to remove a column from a table.

suppose we have a column address in table employee.

To see the description of table we use
desc employee
that will produce following result
here we can see the description of table.

if we want to eliminate the column address from employee table then we use Drop command.
Syntax:

Drop query

Here address is successfully removed.

Please follow and like us:
error

Leave a comment

Your email address will not be published.