Removing a column in table

[ronnie]

Originally posted by marist89
Clearly, Undo is used: http://otn.oracle.com/docs/products/...2a.htm#2055873

SQL> create table testaaa ( a number,
2 b number);

Table created.

SQL> alter table testaaa drop column b;

Table altered.

SQL> desc testaaa
Name Null? Type
----------------------------------------- -------- ----------------------------
A NUMBER

SQL> rollback;

Rollback complete.

SQL> desc testaaa
Name Null? Type
----------------------------------------- -------- ----------------------------
A NUMBER