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
95213 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 is data type in sql?

919

What is localdb mssqllocaldb?

1017

what is the use of friend function? : Sql dba

971

What is the purpose of the primary key?

1005

How to create a menu in sqlplus or pl/sql?

1063

Can I call a procedure inside a function?

945

how to convert character strings to dates? : Sql dba

983

what are all the different normalizations? : Sql dba

960

What is a database? Explain

1050

What does subquery mean in sql?

989

Why we use stored procedure instead of query?

951

What is mdf ldf and ndf?

931

How do I count rows in sql?

947

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

1133

what is query cache in mysql? : Sql dba

991