Post reply

Defining Keys through Management Studio

  • May 10, 2006 at 9:06 am

    #168284

    Hi,

    I am using SQL Server 2005.

    I have created the tables for my Database through the Management Studio front end tool.

    I can apply a primary key to the tables easily enough. What I am having trouble with is assigning multiple columns as primary keys and also how to define foreign keys between tables.

    Does anyone have suggesstions how I can achieve this through management studio?

    Thanks In Advance

    Macca

  • May 11, 2006 at 8:54 am

    #637285

    Macca:

    In Management Studio:  If you right-click on the table you want to modify, and choose "Modify":

    * You should be able to select more than one field for a primary key if you hold down the SHIFT key while selecting the multiple fields and then right-mouse clicking and choosing "Set Primary Key".

    * To add foreign keys, right-mouse click (in the "Modify" window) and choose the "Relationships" option.

    Hope that helps.

    Have a good day,

    Norene Malaney

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

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