Click here to Skip to main content
15,898,995 members
Search within:


How can we make a primary key with non clustered index in SQL SERVER ?
Please Sign up or sign in to vote.
0.00/5 (No votes)
How can we make a primary key with non clustered index in SQL SERVER ???
Posted
Add a Solution

2 solutions

Have a look at the 'Examples section' here[^].

Side note: A non-clustered index is automatically created when we define primary keys if an index on the table does not already exist.
 
Share this answer
 
Posted
Updated 26-May-11 22:45pm
v3
Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month
Related Questions
Sql Server Index (Clustered/ Non Clustered)
Can we Delete Clusters Index In Primary key
using non clustered and clustered index but no effect on time execution in sql
Relationship between primary key and cluster index
Non Clustered Index to help Clustered Index ? (Corrected!)
Cluster and Non Cluster index
Doubt in clustered and non clustered index
Primary Key vs Unique Not Null Clustered Index
how we can create non clustered index on primary key column in oracle?
clustered index on primary key I

Advertise
Privacy
Cookies
Terms of Use
Last Updated 27 May 2011
Layout: fixed | fluid
Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web04 2.8:2024-05-14:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900