Post reply

how to declare Composite key in Enterprise manager??

  • June 2, 2006 at 3:24 am

    #94253

    how to declare Composite Key in Enterprise Manager In Sql Server 2000??

    In a table we already define the primary key but we did not know how to define/declare Composite...

  • June 2, 2006 at 3:45 am

    #641371

    hi,

    hold the ctrl key down and select both (or more) rows. When highlighted, press the key button, and the key icon should appear next to both fields

    HTH

    Paul

  • June 2, 2006 at 3:46 am

    #641372

    all this is in the table designer in enterprise manager

  • June 5, 2006 at 6:55 am

    #641646

    You just recently asked this same question here: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=284300#bm284434

    I assume that previous post did not answer your question.

    A composite key is simply a primary key that consists of two or more columns.  Therefore, you do not declare a primary key and a composite key separately, because they are the same thing.  You can create unique indexes on other columns besides the primary key. This may be done if you have a large natural key (that is, the key is a composite key comprised of several columns), but want to use an identity column as the primary key.

Viewing 4 posts - 1 through 3 (of 3 total)

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