Can we create index as a promary key for SQL server table?how?

Question

Post reply

Can we create index as a promary key for SQL server table?how?

ramana 45417

Grasshopper

Points: 11
More actions
February 9, 2011 at 2:04 am

#234713

Can we create index as a promary key for SQL server table?how?

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259197 More actions · Answer 1

ramana 45417 (2/9/2011)
Can we create index as a promary key for SQL server table?how?

It is the other way around.

If you create a primary key on one or more columns, the database will automatically create a clustered index on those columns (following defaults of course).

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 2

ramana 45417 (2/9/2011)
Can we create index as a promary key for SQL server table?how?

ramana,

Read here

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/