DB Designer creates compound primary key
Posted
by Jon Winstanley
on Stack Overflow
See other posts from Stack Overflow
or by Jon Winstanley
Published on 2010-03-19T12:13:51Z
Indexed on
2010/03/22
17:31 UTC
Read the original article
Hit count: 407
When adding relationships to a database model in DB Designer 4, a composite primary key is being created every time.
So every foreign key I add, I get an extra key added to a composite primary key.
I think I must have changed a setting as I don't remember it doing this in the past.
Does anyone know how to turn off this feature as I prefer to use a single surrogate primary keys in my database tables?
© Stack Overflow or respective owner