Re: how to drop a column?

From: mike <skyxx_at_263.net>
Date: Fri, 1 Sep 2000 12:11:46 +0800
Message-ID: <8ona6f$1d8g$1@news.cz.js.cn>

dear liang:

    it doesn't work too.
    my oracle version is 8.0.5
    but i found i can use vb's datalink window to delete a column.     so i want to trace the sql vb sent to oracle,now have another question,     i dont't know such a tool to trace the sql to oracle , ms sql's trace tool only trace the sql to ms sql server.

           thanx
           mike 2000/9/1

    "liang" <liangluosheng_at_china.com> wrote in message news:8oklqb$1uif$1_at_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 Thu Aug 31 2000 - 23:11:46 CDT