• parthenitin (4/3/2010)


    When we creates the primary key it alwas enforce to create as Clustured.

    how it will enforce to create as NonClustered.

    Please Can u tell me.

    In addition to the reply by Paul -- if there is already a clutered index on the table, then the index for the primary key will also default to nonclustered.


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/