Can a table have two primary keys?

Answer Posted / chandu

We can create only one Primary kay in a table but it can
have multiple columns, of them we only choose 1 column as
identifiable column called primary key and the other columns
are called candidate key(s).

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is assignment operator in pl sql?

772


What are sql constraints?

798


What are the various levels of constraints?

864


What are hotfixes and patches?

695


What is clustered and nonclustered index in sql?

711


What is the difference between delete, truncate and drop command?

760


What are the different type of joins in sql?

726


Can you have more than one key in a database?

697


Can we edit a view in sql?

718


What are inbuilt functions in sql?

797


How many unique keys can a table have?

747


Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

669


What is cte sql?

722


How do you optimize a stored procedure in sql?

697


What is the difference between delete and truncate commands?

695