rem ----------------------------------------------------------------------- rem Filename: dropcol.sql rem Purpose: Demonstrate Oracle8i drop column functionality rem Date: 28-Aug-1998 rem Author: Frank Naude, Oracle FAQ rem ----------------------------------------------------------------------- -- drop table x -- / create table x(a date, b date, c date) / -- Drop column B: alter table x set unused column b -- Mark col as UNUSED / select * from sys.dba_unused_col_tabs / alter table x drop unused columns / -- Drop column C (different method): alter table x drop column c cascade constraints /