Re: SQL Alter table: can I remove the UNIQUE attribute from a key?

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Hi Joel

I know I'm replying late to this, but I think there's a point of 
confusion here.

A UNIQUE attribute on a PF is not a primary key constraint. The latter 
is an SQL concept. You can't create a primary key from DDS. You CAN 
ADDPFCST to add a primary key constraint to a PF from a command line.

Hence, one of the replies talked of using a few ALTER TABLE statements 
to effect what you want.

But because this is not an SQL attribute, Chuck's CHGPF idea is what I 
would prefer doing.

OK, it IS the weekend!

Vern

On 5/2/2013 9:55 AM, Stone, Joel wrote:
> The UNIQUE key to this file was created as primary from DDS.
>
> Can I either:
>
>
> 1)      Remove the UNIQUE attribute of the column using SQL ALTER, or
>
> 2)      Can I DROP the field and ADD the column back to the BEGINNING position (1st column)?
>
> Thanks!
>
>
>
> ______________________________________________________________________
> This outbound email has been scanned for all viruses by the MessageLabs Skyscan service.
> For more information please visit http://www.symanteccloud.com
> ______________________________________________________________________