venoym (6/14/2012)
Is the intent to test your Index DEFAULT (as the name of the QotD implies), in which case the answer CLUSTERED is correct.
No, that's not correct.
The default for a primary key is a clustered index, UNLESS another clustered index is specified in the CREATE TABLE statement.
You just can't drop the sentence after "unless".
Logically, that would be the same as saying that
C = A ^ B
equals to
C = A
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP