Great question Hugo.

This is a statement that supports the answer:

CREATE TABLE dbo.QotD2

(KeyColumn INT NOT NULL PRIMARY KEY

,Test INT NOT NULL

,CONSTRAINT [UX_Test] UNIQUE CLUSTERED

(

Test ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY];