Ya, it is possible.. try with this Query.. create table cust11 ( cno in

Can a table have two primary keys?

Question Posted / kumar navdeep shanker

44 Answers
96328 Views
HCL, MetaCube, I also Faced
E-Mail Answers

Answer Posted / kumar navdeep shanker

Ya, it is possible..
try with this Query..
create table cust11
(
cno int not null,
balance int not null,
cname varchar(10),
CONSTRAINT cust primary key (
cno,balance)
)

If there is any Problem.. plz reply

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are different functions in sql?

922

What is sql engine in oracle?

971

How to take user input in pl sql?

1145

Does sql*plus have a pl/sql engine?

1050

How many clustered indexes can you have?

950

What are all types of user defined functions?

1055

Can we create table in function?

943

What is the maximum rows in csv?

910

How can a pl sql block be executed?

932

what is 'mysqldump'? : Sql dba

1092

Define sql delete statement.

988

Is sql a programming?

961

What is #table in sql?

1068

What is data definition language?

1080

What is oracle sql called?

902