Oracle Lessons: Deleting a Column

	Deleting a Column From a Table

Description

If you have an undesired column that you don't want anymore in a table, you can remove it. To delete a column using SQL code, use the following formula:

ALTER TABLE TableName
DROP COLUMN ColumnName

On the right side of the ALTER TABLE expression, type the name of the table. On the right side of the DROP COLUMN expression, enter the name of the undesired column. Here is an example:

SQL> ALTER TABLE StaffMembers
  2  DROP COLUMN Address;

Table altered.

SQL>