Post reply

Unique Constraint across multiple tables.

  • February 8, 2012 at 3:17 pm

    #252686

    Hi,

    I have a table 'A' (a1 int identity , a2 varchar(10) , a3 int )

    Another table 'B' (b1 int identity, b2 varchar(10))

    A.a3 references B.b1

    I want to enforce a unique constraint on A.a2 and B.b2. (i.e the combination of A.a2 and B.b2 should be unique)

    Can you help..?

  • February 8, 2012 at 3:32 pm

    #1444827

    This[/url] seems to be what you're after.

    Hope this helps

    Gianluca

    -- Gianluca Sartori

  • February 8, 2012 at 4:10 pm

    #1444834

    That helped....thanks!!!

  • February 8, 2012 at 5:04 pm

    #1444839

    Glad I could help.

    -- Gianluca Sartori

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

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