Re: alter question

On Fri, 10 Apr 1998 22:13:33 -0400, Jerry Gitomer <jgitomer_at_p3.net> wrote:

>
> 1. RENAME table TO temp_name;
> 2. Edit the DDL you used to create the table and change the column
>name
> 3. Run the DDL statement
> 4. INSERT INTO table SELECT * FROM temp_name;
>
>If you don't wish to recreate the table there are two alternatives that
>might be suitable. The first is to create a view of the table with only
>the one column name changed. The second is always use an alias when
>selecting the column, e.g.
>
> SELECT column1, column2, ugly_name good_name, columnx FROM table;
>
>Regards
>
>Jerry
>
>

Does anyone have a reasonable explanation why Oracle hasn't implemented the following commands?

ALTER TABLE DROP COLUMN columnname
ALTER TABLE RENAME COLUMN columnname

Does Oracle think that they aren't useful?

Thanks,

Nuno Guerreiro Received on Wed Apr 15 1998 - 05:27:20 CDT