Getting Started with Adobe After Effects - Part 6: Motion Blur
This module helps you to share, discuss and learn interview questions and answers of different technologies

SQL Server - Is it possible to create a Non-Clustered Index on primary key column?

Mar 20 2012 12:00AM by Ramireddy   

Question

In SQL Server, on a primary key column, is it possible to create Non-Clustered index?

Answer

Yes. Its possible to create the Non-Clustered Index on a primary key column. We can use below syntax to create Non-CI on primary key column while creating table itself.

Create table Customers
(
    CID int identity(1,1) primary key Nonclustered
)

Read More..   [32134 clicks]

Published under: SQL Server Interview Questions ·  ·  ·  · 


Ramireddy
2 · 40% · 12972
0
Liked
 
0
Asked



Submit

Your Comment


Sign Up or Login to post a comment.

"SQL Server - Is it possible to create a Non-Clustered Index on primary key column?" rated 5 out of 5 by 9 readers
SQL Server - Is it possible to create a Non-Clustered Index on primary key column? , 5.0 out of 5 based on 9 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]