Re: Q: How to rename columns?

Alexander:

I don't believe this is possible. You'd have to recreate it with the corrected name or rename the table, from "data" to say "foo," then create a view on the table called "data" with the desired field name (in which case you need to create all new indices and referential integrity/constraints, etc.).

-Peter

On 21 May 1996 20:57:56 GMT, adelnef_at_odin.bwl.uni-mainz.de (Alexander Delnef) wrote:

>Hi there,
>
>is there a way to change a primary key constrained column in a table
>via SQL or with the Object Manager?
>
>When I tried it with the Obj Mgr it didn't allow it and I do not
>see a possibility via SQL because
>
>Alter table <tablename> modify <columnname> ...
>
>does not *rename the column.
>
>Any hint is welcome,
>
>TIA
>
>Alexander
>
Received on Thu May 23 1996 - 00:00:00 CEST