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
96845 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

How to connect a sql*plus session to an oracle server?

1130

What is a procedure in pl sql?

1215

What are the different sql commands?

1075

How many sql commands are there?

1119

Why function is used in sql?

951

How to avoid duplicate records in a query?

1009

What is difference between nchar and nvarchar?

1029

what is the different between now() and current_date()? : Sql dba

1026

How global cursor can be declare with dynamic trigger ?

2211

what is dbms? : Sql dba

1001

How to add a column ‘salary’ to a table employee_details?

1013

Can we use pl sql in sql server?

1086

Is pl sql still used?

981

Can you selectively load only those records that you need? : aql loader

1048

What is sqlite used for?

1007