Post reply

Question about the QA

  • June 20, 2003 at 7:01 am

    #64865

    Hello,

    When I create a Primary Key Constraint, the constraint shows up in the 'Constraints' folder of the table I created the PK constraint on.

    Since a PK constraint also creates an index, why would there not be an entry in the 'Indexes' folder of the same table for the PK?

    Thanks!

    CSDunn

  • June 20, 2003 at 5:32 pm

    #462500

    That's a good question. Check out BOL keyword "constraints, PRIMARY KEY" for some info on it. The gist of the matter seems to be that Primary Key's are more than just a clustered or nonclustered index...they're a "unique" index as well by default.

    Weird...

    cl

    Signature is NULL

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply