Can a table have two primary keys?
Answers were Sorted based on User's Feedback
Answer / vineet
A Table can have only one primary key but it is possible to
have more than 1 primary key attributes i.e candidate key.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / avdhesh
One Table can contain only One Pk But can Have more than One
Unique Key
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / balaji
a table can have only one primary key.
u can make another primary key
that is called a composite primary key
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / saurabh
No, a table can have one and only one primary key.
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / sandeep gogoi
yes! it possibly have 2 primary keys as a combination of
such keys should not repeated!...
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / uhaish
Yes and it can and the number of primary keys in a single
table is not limited and can be 3,4, unlimited .The concept
is imagine 2 primary keys cols in a table as one primary
key col .
which means if you have two cols A and B both are primary
key by defination then..
AB
00
01
02
12
21
21
22
,see individually a primary key col is not anymore unique
but as hole its unique no other row in a table can have the
same combination of these two primary keys i.e '02' cannot
be repeated .
Is This Answer Correct ? | 2 Yes | 2 No |
we can create more than one primary key in a table. the
maximum allowed to create primary keys for columns is 16,
but we call it primary key for one column only and the
remaining we call it as composite primary key..
create table TestPrimaryKey(ID int,Name nvarchar(50),Email
nvarchar(50),Phone nvarchar(12),cellphone nvarchar
(10),primary key(ID,Name,Email,Phone,cellphone))
the above table creates primary key for all above mentioned
columns.
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / antonis flangofas
ofc you can, stop giving to ppl wrong answers here it is
CREATE TABLE track(
album CHAR(10),
disk INTEGER,
posn INTEGER,
song VARCHAR(255),
PRIMARY KEY (album, disk, posn)
)
if you want to avoid to have id you use this way.
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / dan
Kumar Navdeep Shanker
I have created the table provided and it works well.
You said that is possible to have two primary key, I am
sorry I have to disagree with you and all who said yes.
Let me explain using your table
cno balance cname
1 2 w
2 2 x
1 3 r
primary key no two tuple have the same value
what you are providing is a composite key
Thus, we can have more than one key in a table that the
compinaition of the keys are unique
BUT we have only one primary key that means it is unique
Please correct me if i am wrong
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / san
Yes we can keep but it become composite key
means primary key for that perticular coloum only
Is This Answer Correct ? | 0 Yes | 0 No |
How to display the contents of a current record fetched in a reference cursor?
What are different types of keys?
How many types of primary keys are there?
Why should I use postgresql?
Write a unique difference between a function and a stored procedure.
What is intersect?
What is synonyms?
What is an Exception ? What are types of Exception ?
Explain UNION,MINUS,UNION ALL, INTERSECT?
What is graph sql?
If I have a table T with 4 rows & 2 columns A & B. A has values 1,2,3,4. and B has 10,20,30,40. Write an Update SQL query which can Swap the values of A & B for all records. (Do not use a sub-query)
Are sql views compiled?