Home

SQL Keywords: DROP

 

Deleting a Column

The DROP keyword is used to delete an object. It can be used to remove a column from a table. The formula to use is:

ALTER TABLE TableName DROP COLUMN ColumnName;

or

ALTER TABLE TableName
DROP COLUMN ColumnName

Here is an example:

ALTER TABLE Employees DROP COLUMN DateHired;

Description

The DROP keyword can be used to delete a table. Here is an example:

DROP TABLE Employees;

Home Copyright © 2005-2011 FunctionX, Inc