Re: Q: How to rename columns?
From: John Homeyard <homeyard_at_worldnet.att.net>
Date: 1996/05/22
Message-ID: <4o020d$pb3_at_mtinsc01-mgt.ops.worldnet.att.net>#1/1
Date: 1996/05/22
Message-ID: <4o020d$pb3_at_mtinsc01-mgt.ops.worldnet.att.net>#1/1
Check out the sql reference manual for specific uses. alter table table_name drop constraint constraint_name; john.
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 Wed May 22 1996 - 00:00:00 CEST