Post reply

Unique Constraint

  • September 23, 2013 at 4:51 am

    #282864

    I have two columns Student_ID and MAC_ID in my table.

    I want to put Unique constraint on these two columns together.

    I am using SQL Server Management Studio 8 .

    Can you please tell me the steps ?

  • September 23, 2013 at 4:54 am

    #1652286

    spectra (9/23/2013)

    I have two columns Student_ID and MAC_ID in my table.

    I want to put Unique constraint on these two columns together.

    I am using SQL Server Management Studio 8 .

    Can you please tell me the steps ?

    Alter table table_name

    ADD constraint constraint_name UNIQUE (Student_ID, MAC_ID)

    _______________________________________________________________
    To get quick answer follow this link:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

  • September 23, 2013 at 5:00 am

    #1652289

    kapil_kk (9/23/2013)

    spectra (9/23/2013)

    I have two columns Student_ID and MAC_ID in my table.

    I want to put Unique constraint on these two columns together.

    I am using SQL Server Management Studio 8 .

    Can you please tell me the steps ?

    Alter table table_name

    ADD constraint constraint_name UNIQUE (Student_ID, MAC_ID)

    thanks.

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

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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy