top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How can one drop a column from a table in Oracle 8i?

+2 votes
112 views
posted Jun 24, 2015 by Archana

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

Physically Removing the Column

The other method for dropping an unnecessary table column is through the use of the the alter table name drop column colname statement. This statement actually removes all data from the column and eliminates the column from the table definition. This operation may take more time to complete than marking the column as unused, because Oracle has to go through all blocks of the table and actually remove the column data in order to reclaim the space used by that column. The following is an example of physically removing a table column:

 ALTER TABLE d_table DROP COLUMN d_column CASCADE CONSTRAINTS;
answer Nov 4, 2015 by Shivaranjini
...