Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: how to drop a column?

Re: how to drop a column?

From: liang <liangluosheng_at_china.com>
Date: Thu, 31 Aug 2000 12:12:58 +0800
Message-ID: <8oklqb$1uif$1@news.cz.js.cn>

Hi!Mike

Try this:
ALTER TABLE tablename DROP (columnname) CASCADE CONSTRAINTS;

"mike" <skyxx_at_263.net> wrote in message news: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?
>
>
Received on Wed Aug 30 2000 - 23:12:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US