Re: "Alter table" syntax command ?

From: Ravinder Reddy Anumula <ranumula_at_cncx.com>
Date: 23 Jun 1998 20:38:57 EDT
Message-ID: <35904A90.27F996F9@cncx.com>

Patrick Marcouly wrote:

> Hahaha, you don't undertand my first message... Sorry for my poor English.
>
> My problem is not to add a column, but to drop a column.
> I added a column by mistake, and now i try to drop it.
>
> Some gentle people said me that a dropping column command don't exist in
> Oracle 7.3.
> The only solution is to recreate another table based on the first one,
> without the wrong column.
> Of course, this implies to save data, recreate Indexes, grants, etc... What
> a bunch of work !
>
> Could anyone help me ? I'm looking for a command for diagnosing all indexes
> existing on a table.
> Something like :
> SELECT INDEX_NAME, INDEX_KEY FROM INDEX_LIST WHERE
> INDEX_LIST.TABLE_NAME = 'MY_TABLE';
Select * from User_Ind_ColumnsWhere Table_Name = 'MY_TABLE';For more information on Index Use the table "USER_INDEXES"

>
>
> Is this kind of command possible ?
>
> Gitte Tøgersen a écrit dans le message <6mnn28$68s$1_at_news.uni-c.dk>...
> >Hi Patrick !
> >
> >You're missing the brackets...
> >
> >alter table MY_TABLE
> >add (NEW_COLL number(length));
> >
> >This should do it....
> >Kind regards
> >Gitte Tøgersen
> >Denmark

--
-Ravi.

---

Ravinder Reddy Anumula. Ph:408-343-2217(Work) Received on Tue Jun 23 1998 - 19:38:57 CDT