Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nskchaitanya
Starting Member
1 Post |
 Posted - 2009-01-16 : 00:25:45
|
| Can we Create Non-Clustered on Primary Key Column and can we Create Clustered Index on Non Primary Key Column. |
|
|
Nageswar9
Aged Yak Warrior
600 Posts |
Posted - 2009-01-16 : 00:47:58
|
| Yes, we can create the Non-Clustered Index on Primary Key Column |
 |
|
|
Nageswar9
Aged Yak Warrior
600 Posts |
Posted - 2009-01-16 : 01:31:12
|
| By default, the clustered index created in primary key column, so we can't create more than one clustered index per table. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Clustered Index