• hi sameer,

    nice question.... you r question it self has the answwer..

    The actual question asked is

    A Primary Key is always enforced by a clustered index at creation?

    which is not always done, it is enforced by a clustered index only when there is no clustered index existing on that table. If there is an clustered index existing in that table, the primary key u r going to create will be enforced by a non clustered index.

    please notice the word "always" in the question...

    🙂

    [font="Times New Roman"]Anil Kubireddi[/font]