Reorder Primary Key - any problem?

[t53864]

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?

[Phil]

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?

Primary key index would have different column ordering. Might impact
performance depending on your queries.