Re: how to drop a column?

mike <skyxx_at_263.net> schrieb in im Newsbeitrag: 8oht9l$24ud$1_at_news.cz.js.cn...
> hi all:
> i am beginer of oracle.i created a table ,now i must drop a column of
> it,how can i do?
>
>

ALTER TABLE table_name DROP (columnname) [CASCADE CONSTRAINTS];

The cascade constraints is only necessay if the column has some referential integrities.

Mike Received on Wed Aug 30 2000 - 06:30:00 CDT