I typically use compound primary keys when creating a table that represents a many-to-many relationship. I was wondering if anyone else had other situations in which you would use a compound PK? Why do you use it instead of just a foreign key?
I typically use compound primary keys when creating a table that represents a many-to-many relationship. I was wondering if anyone else had other situations in which you would use a compound PK? Why do you use it instead of just a foreign key?
|