What is the difference between a candidate key an a secondary key?

1 answer

Answer

1192132

2026-07-22 22:00

+ Follow

A candidate key is a unique key that can uniquely identify each record in a database table, whereas a secondary key is a non-unique key used for data retrieval and indexing purposes. Candidate keys can be chosen as the primary key for the table, while secondary keys provide alternate ways to access and organize the data.

ReportLike(0ShareFavorite

Copyright © 2026 eLLeNow.com All Rights Reserved.