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?

Perhaps no affect and perhaps a complete disaster. Depends on child tables and foreign keys. Test ... test ... test.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)