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 ·  ·  ·  ·