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

is mysql query is case sensitive? : Sql dba

1163

What is materialized view. What are different methods of refresh?

1438

What is the use of index in hive?

1052

What is the starting oracle error number?

1096

Is oracel sql developer written in java?

1167

Can we change the table name in sql?

1000

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1116

Does truncate release storage space?

1135

How do I view a sql database?

1060

Does google use sql?

1006

What is a join?

1104

Explain constraints in sql?

1085

What is difference between nchar and nvarchar?

1100

What is auto increment feature in sql?

1174

What does seeding a database mean?

1015