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.

Answer / avdhesh

One Table can contain only One Pk But can Have more than One
Unique Key

Answer / balaji

a table can have only one primary key.
u can make another primary key
that is called a composite primary key

Answer / saurabh

No, a table can have one and only one primary key.

Answer / sandeep gogoi

yes! it possibly have 2 primary keys as a combination of
such keys should not repeated!...

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 .

Answer / murali krishna penke

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.

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.

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

Answer / san

Yes we can keep but it become composite key
means primary key for that perticular coloum only

Why we use triggers in mysql?

0 Answers  

when a procedure /package is getting invalidated?

4 Answers   TCS,

1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...

0 Answers   Satyam,

How can I delete duplicate rows?

0 Answers  

Can you select everything, but 1 or 2 fields, without writer's cramp?

0 Answers  

What is bitemporal narrowing?

0 Answers  

How many joins in sql?

0 Answers  

Why is the cursor important?

0 Answers  

Is sql port 1433 encrypted?

0 Answers  

What is scalar function in sql?

0 Answers  

What is difference between joins and union?

0 Answers  

how to include numeric values in sql statements? : Sql dba

0 Answers