There is possible more than one primary key in table | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 2

There is possible more than one primary key in table

20th Nov 2016, 8:34 AM
MEHTA MESHWA
MEHTA MESHWA - avatar
4 Answers
+ 2
what is foreign key?
20th Nov 2016, 1:39 PM
MEHTA MESHWA
MEHTA MESHWA - avatar
+ 1
you can only have one primary key in a table. you can have as many foreign keys as possible
20th Nov 2016, 10:18 AM
Agaba Ivan
Agaba Ivan - avatar
0
You can only have one primary key per table, but it is possible to have a composite primary key consisting of multiple fields.
21st Nov 2016, 2:53 AM
Zach
0
@meshwa: a foreign key is a primary key in another table. It means that values in one table (where you have your foreign key) must also appear in another table (where this value is the primary key). So, it's just reference from one table to another.
21st Nov 2016, 7:17 AM
Pavel Gazin
Pavel Gazin - avatar