CODEWITHSUNDEEP
sql-serverindexingprimary-keyidentity
v s
v s

Reputation: 559

Should I always make an Identity column Primary Key for the table?

If I create a table with Identity column, should I always make it PK for the table. I know when we do it automatically creates a clustered index for that table. Is there any perfomance hit keeping all identity columns in tables without making them PK? Any suggestions?

Upvotes: 0

Views: 250

Answers (1)

Sky5005e
Sky5005e

Reputation: 79

If you want to use that table in C# using linq then there will need to put PK.

Upvotes: 1

Related Questions