Re: "Alter table" syntax command ?

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 Tue Jun 23 1998 - 04:38:28 CDT