Can a table have two primary keys?

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 the types of optimization?

695


Show the two pl/sql cursor exceptions.

810


What does subquery mean in sql?

744


Where not exists in sql?

681


how tsql statements can be written and submitted to the database engine? : Transact sql

720


What is a file delimiter?

749


Which sql most popular?

732


Explian rowid, rownum?

759


what is the difference between blob and text? : Sql dba

734


What is pls_integer in pl sql?

762


What is information schema in sql?

777


How do I run sql profiler?

771


Explain the order of sql statement execution?

812


Mention what is the use of function "module procedure" in pl/sql?

796


What are different joins used in sql?

747