Primary keys and indexes

Question

Post reply

Primary keys and indexes

meichner

SSCertifiable

Points: 5563
More actions
May 6, 2009 at 7:21 am

#130679

I have a simple question about SQL Server. When I define a field on a table as the primary key, does SQL Server automatically create a corresponding index on that field or do I need to create the index myself.
Thanks

Viewing 8 posts - 1 through 7 (of 7 total)

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

Ken Simmons SSCertifiable Points: 7822 More actions · Answer 1

By default SQL Server creates a clustered index on the primary key.

meichner SSCertifiable Points: 5563 More actions · Answer 2

Ken Simmons (5/6/2009)
By default SQL Server creates a clustered index on the primary key.

Thanks for the fast response.

grigoriadis1 SSC Journeyman Points: 81 More actions · Answer 3

Anyone know what query I could use to set a primary key using a syntax on a table?

AndrewSQLDBA SSC-Insane Points: 21827 More actions · Answer 4

Look in the SQL Books Online under "Alter Table"

Andrew SQLDBA

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

Is google down today?

http://msdn.microsoft.com/en-us/library/ms190273.aspx

There are several examples at the bottom

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

G.R.Prithiviraj Kulasingham SSCarpal Tunnel Points: 4105 More actions · Answer 6

GilaMonster (1/24/2010)
Is google down today?
http://msdn.microsoft.com/en-us/library/ms190273.aspx
There are several examples at the bottom

As Google is not down, we expect you to do the search 🙂 Just kidding.

Cheers,
Prithiviraj Kulasingham

http://preethiviraj.blogspot.com/

homebrew01 SSC Guru Points: 55548 More actions · Answer 7

GilaMonster (1/24/2010)
Is google down today?

Not again ??!! 😀