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.


Leave a comment

Your email address will not be published.

Managed by MochaHost - Fast & Easy WordPress Hosting