using primary keys in sql server

Question

when i create primary key on a column 'FirstName', is a clustered index automatically created for this column?

marc_s · Accepted Answer · 2011-03-23 07:06:21Z

1

Yes - this is default SQL Server behavior.

It doesn't have to be that way - if you create your PK using T-SQL script, you can also choose to make it a non-clustered PK and put the clustering key on another column.

ALTER TABLE dbo.YourTable
    ADD CONSTRAINT PK_YourTable
    PRIMARY KEY NONCLUSTERED(FirstName)

CREATE CLUSTERED INDEX CIX_YourTable
    ON dbo.YourTable(SomeOtherColumn)

In this case, FirstName would be the (non-clustered) primary key on your table, while SomeOtherColumn would be the clustering key for that same table.

answered Mar 23, 2011 at 7:06

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

nvogel · Accepted Answer · 2011-03-23 07:37:57Z

1

Depends on what you specify when you create the key. Indexes are automatically created for key constraints by SQL Server but as part of the constraint syntax you can specify either CLUSTERED or NONCLUSTERED.

answered Mar 23, 2011 at 7:37

nvogel

25.6k3 gold badges47 silver badges89 bronze badges

Collectives™ on Stack Overflow

using primary keys in sql server

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related