Re: Reorder Primary Key - any problem?

t53864 wrote:

> I need to reorder the primary key of a table. Say,
>
> Primary Key (field1, field2)
>
> changed to:
>
> Primary Key (field2, field1)
>
> Would like to know if this creates any problem to the
> database?

Unless ur application does not failover then yes It is Valid and does not cause any problems to the DB... Make sure u analyze the tables after u do this operation.

-- 

Cheers
Ganesh Raja
ganesh.raja_at_nospam.mantas.com
<Remove nospam to Mail>