Are Primary Key columns indexed by default????

[stiej]

Hello,

Is a primary key (apart from being unique) also an index? Or is it possible to have unindexed primary keys?

thanks!

 

[Jamfool]

BOL

SQL Server automatically creates a unique index to enforce the uniqueness requirement of the PRIMARY KEY constraint. If a clustered index does not already exist on the table, or a nonclustered index is not explicitly specified, a unique, clustered index is created to enforce the PRIMARY KEY constraint.

 

[gmmastros]

Primary keys are indexed by default. In fact, the primary key is implemented through a unique index and is usually clustered. Clustered Indexes are better/faster than 'regular' indexes, but you can only have 1 clustered index per table.

>> Or is it possible to have unindexed primary keys?

It is not possible to have a primary key without having an index. Is this a problem for you?

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[SQLDenis]

Or is it possible to have unindexed primary keys?
If you want to create an identity field you will accomplish that, it will be unique and not indexed

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[stiej]

thanks guys. i was not actually wanting to make a non indexed primary key, i was just didnt know whether ornot pk's are indexed. thanks again.