is there more the two primary key in a single table?

Answer Posted / sudheer gowlikar

we cannot have more than one primary key on a table since
primary will create a clustered index and we can have only
1 clustered index on a table since clustered index will
sort data in data pages and the data sorted in one way
rather sorting number of ways.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why we use functions in sql server?

511


What is the dbcc command and why is it used?

560


How do I clean up sql server transaction log?

559


Can a function call a stored procedure in sql server?

520


What are 3 ways to get a count of the number of records in a table?

602






How to update muliple row in single query?

603


What is 2nf normalization?

531


How to reaname table name without using sp_Rename in sql server..?

523


What is abstracting periodical?

518


How to return the second 5 rows in ms sql server?

624


What function does a database engine serve in the sql server?

561


What is a recursive stored procedure in sql server?

556


What is a partition function in sql server?

530


How many full-text indexes can a table have?

544


Is sql server 2016 free?

524