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 Reply

Your email address will not be published.