Re: [Beginner] How to destroy a column in a table

From: Guido Konsolke <gk61_at_gmx.net>
Date: Thu, 13 Jun 2002 08:38:54 +0200
Message-ID: <1023949518.581431_at_news.thyssen.com>


"tuan do thuong" <tdothuon_at_etu.utc.fr> wrote...
> Hi.
> I would like to know how to destroy a column in a table in Oracle.

Hi,
do you really want us to guess about the dbms version you use? What error do you get?
You'll see: more information, better answers.

> I have tried :
> ALTER TABLE PERSONNE DROP NAME
> but it didn't work.

Try: ALTER TABLE PERSONNE DROP COLUMN NAME

>
> Thanx.
>

You're welcome.
Guido Received on Thu Jun 13 2002 - 08:38:54 CEST

Original text of this message