SQL> desc awsf1;
Name Type Nullable Default Comments
------ ------------ -------- ------- --------
WORKNO VARCHAR2(5)
W_NAME VARCHAR2(12) Y

SQL> alter table awsf set unused column w_name;

Table altered

SQL> alter table awsf drop unused columns;

Table altered

SQL> desc awsf1;
Name Type Nullable Default Comments
------ ------------ -------- ------- --------
WORKNO VARCHAR2(5)
W_NAME VARCHAR2(12) Y

[@more@]

ITPub博客

删除表中的字段（转）