Nagaraj Tantri
Reputation: 11
Is it possible to break a Composite key?
Is it possible to break the composite key of a table and use one of them as a primary key for other table? If yes, then please tell me how can I do it?
Upvotes: 1
Views: 176
Answers (1)
Mark Byers
Reputation: 838876
Generally you use a composite key when none of the columns alone contains unique values. Since a primary key must be unique, you probably can't use just one of the columns.
Upvotes: 2
Related Questions
- Only one key from composite primary key as foreign key
- Can one field in a composite key be dependent on the other?
- Composite Key becomes not unique
- Can a foreign key of a table be a part of the composite primary key of the same table?
- SQL Server 2008: can 2 tables have the same composite primary key?
- Composite key in SQLite
- Composite primary key
- Can part of a composite primary key be used as part of a composite primary key on another table?
- Is it possible to have a foreign key which isn't covering the whole primary key of the referenced table?
- Can a Compound key be set as a primary key to another table?