give differences between alternate key and foreign key
Answers
Answered by
0
Answer:
Primary key uniquely identify a record in the table. By default, Primary key is clustered index and data in the database table is physically organized in the sequence of clustered index. ... Foreign key do not automatically create an index, clustered or non-clustered.
Answered by
0
Answer:
Alternate keys are those Candidate keys that were not chosen to be the Primary key of the table. Composite key is a Candidate key that consists of more than one attribute. Foreign key is an attribute which is a Primary key in its parent table but is included as an attribute in the host table.
Explanation:
Similar questions