Can a table have two primary keys?

Answer Posted / dev lamani

no a table can have only one primary key.
u can make one or column to have primary key
that is called a composite primary key


Dev
ddlamani@yahoo.com

Is This Answer Correct ?    61 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how many columns can be used for creating index? : Sql dba

532


What is sql and also describe types of sql statements?

573


What do you mean by stored procedures? How do we use it?

549


What is full form of rtm?

545


How will you distinguish a global variable with a local variable in pl/sql?

641






How is use pl and sql?

566


what is auto increment? : Sql dba

585


Does truncate need commit?

526


how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

792


What is difference between inner join and self join?

606


what are the advantages and disadvantages of views in a database? : Sql dba

547


Is it important to partition hard disk?

545


Can we use ddl commands in pl sql?

571


What trigger means?

578


What are the advantages of indexing?

538