Home Forums SQL Server 2008 SQL Server Newbies PRIMARY KEY VS UNIQUE KEY* RE: PRIMARY KEY VS UNIQUE KEY*

  • July 30, 2013 at 5:01 am

    #1636914

    On the other hand, an Unique Index is an index that doesn't allow for duplicate values but it is not a Referential Integrity constraint.

    Paul,what exactly you mean by that..

    As we can have referential integrity constraint column referring on unique key columns also...

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/