Added New Column to Existing Table/Part of 1ary Key Now

[Coder7]

Good afternoon.

I added 3 new columns to an existing table. I modified the table's primary key to include one of the new columns that I added.

1ary key was:
eval_id, eval_seq_nbr, type, code

1ary key now:
eval_id, eval_seq_nbr, type, code, lineup_seq_nbr

I have never done anything w/keys before so I need caveats. What should I be checking to see what has been affected by this change?

Thanks all and have a great week.

 

[dmhirsch]

Watch out for tables that export that primary key as a foreign key; they need to change too.