What are primary key , candidate key and a alternate key ?
Answers
Answered by
8
A column or a set of columns can be called as candidate key if they identify each row of a table uniquely. A table can have multiplecandidate keys. One of them is specified as Primary key and rest of them can be called as alternate ke
Answered by
4
Answer:
Primary Key-A primary key is unique relation database table column designated to uniquely identify all table records
Candidate Key-A candidate key is a column, or set of columns, in a table that can uniquely identify any database record without referring to any other data.
Alternate Key-An alternate key is a key associated with one or more columns whose values uniquely identify every row in the table, but which is not the primary key.
Similar questions