+ 1

primary key?

how to create a table with 2 primary keys? not using candidate key?

6th Mar 2017, 5:06 PM
GADE. NAVEEN
GADE. NAVEEN - avatar
6 Answers
+ 6
why would you need 2 primary keys? pls elaborate
6th Mar 2017, 5:15 PM
Andre van Rensburg
Andre van Rensburg - avatar
+ 4
You can only have one primary key :) but you can have a Composite Primary Key which is a primary key made from two or more columns. like that :- primary key (S-ID, GPA)
7th Mar 2017, 6:02 PM
Nayra Adel
Nayra Adel - avatar
+ 1
You cannot have2 PK in a table
6th Mar 2017, 6:12 PM
Meharban Singh
Meharban Singh - avatar
0
i possible
6th Mar 2017, 5:07 PM
GADE. NAVEEN
GADE. NAVEEN - avatar
0
there is no scope of using two primary keys together
22nd Apr 2017, 4:54 AM
nitin choudhary
nitin choudhary - avatar
0
identifies the uniqueness of the records in the database and ignores the redundancy of the data
13th May 2017, 2:46 AM
AlkhidierAbdalla Bakhiet idriss
AlkhidierAbdalla Bakhiet idriss - avatar