In Sql Server (2008), is it possible to have a
PRIMARY KEY on a set of columns without either
NONCLUSTERED indexes on the same set of columns?
I am aware of the fact that
PRIMARY KEY and
CLUSTERED INDEX key are separate concepts and that we can create
PRIMARY KEY without
CLUSTERED INDEX on it (see below).
ALTER TABLE dbo.Sample ADD CONSTRAINT PK_Sample_SeqGUID_Col1 PRIMARY KEY NONCLUSTERED (SeqGUID_Col1)
But my question is to see if it is possible to create
PRIMARY KEY on a table without a
NONCLUSTERED index on it.