• amit_adarsh (6/14/2012)


    I don't think the answer is correct for the question (mentioed in screen shot).Because if you write like this , it will create

    a key that is treated as Primary Key and index wise it is clustered index

    Please read the question carefully:

    Below you see a part of a CREATE TABLE statement.

    -- More column and constraint definitions below

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP