Primary key unique key candidate key | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

Primary key unique key candidate key

17th Nov 2016, 4:51 PM
Deep Patel
Deep Patel - avatar
5 Answers
+ 2
what's the question, please?
17th Nov 2016, 6:10 PM
Álvaro
+ 2
As far as I know, a (unique) key for a table is a column (or set of columns) such that there are no two records with the same value for that key. There can be several keys for a table. Once you choose a key to be *the* primary key for a table, the rest of keys become candidate keys.
17th Nov 2016, 7:59 PM
Álvaro
0
what is definitioñof this keys
17th Nov 2016, 6:19 PM
Deep Patel
Deep Patel - avatar
0
Your primary key is the column name which has to have a unique value for every entry in the table. It is a unique identifier in the case that you need to join more than one table together that have the same column name. For example if you had a primary key named accountnum in table A and then a column named the same thing in table B you could join the tables. The accountnum in table A will be the primary key, and the accountnum in table B will be the foreign key.
18th Nov 2016, 3:35 AM
Brandon
Brandon - avatar
0
PIN kódem
5th Jun 2021, 3:18 AM
Kristýnka
Kristýnka - avatar