Monday, July 24, 2006

How to DROP COLUMN On Oracle TABLE

Sometimes we need to DROP COLUMN from the database table. But, how it works on Oracle?

First, you must set the column as the unused column.
ALTER TABLE TABLE_NAME SET UNUSED COLUMN COLUMN_NAME;

Second, you must drop the unused column.
ALTER TABLE TABLE_NAME DROP UNUSED COLUMNS;

Note :
TABLE_NAME is your database table name.
COLUMN_NAME is your database column on the table.

1 comment:

mobilemob said...

Hi! Just want to say what a nice site. Bye, see you soon.
»