y.koteswarrao-652921 (7/15/2010)
This is an interview question can we create a primary key on table without cluster index?
Yes.
I think it not possible.............Can we forceble ignore the cluster index while creating the primary key...
Primary key and clustered index are different concepts. Primary key is the row's identifier. Clustered index is an index with the data pages at the leaf level.
Only relation is that, by default, the primary key is enforced by a unique clustered index. This is only by default, not by requirement.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability