Re: "Alter table" syntax command ?

Hi again,,,

That was something else.....

It's true that you can't drop one single column from a table, and the only way to get rid of it, is by creating a new table !!

To your other question, about finding the indexes to a specific table, you can get all the information, from the following tables :

all_indexes (here you can get indexes concerning your table) all_ind_columns (here you can get the columns concerning the indexes)

Hope THIS will help you !

'Enjoy' the extra stupid work.....

Kind regards

Gitte Tøgersen
Denmark
Email: danskdata_at_hotmail.com

Patrick Marcouly skrev i meddelelsen
<6mo0mc$ons$1_at_pegase.production.axime.fr>...
>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';
>
>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
>
>
>
Received on Wed Jun 24 1998 - 02:21:39 CDT