Home Forums SQL Server 2005 T-SQL (SS2K5) Unique Constraint for 2 columns in SQL 2005 RE: Unique Constraint for 2 columns in SQL 2005

  • April 1, 2009 at 2:55 am

    #969679

    Vijaya Kadiyala (3/31/2009)

    Hi

    Ramesh, Instead of Unique Constraint why can't we have Unique Index??

    Thanks -- Vijaya Kadiyala

    http://www.dotnetvj.com

    There are no significant differences between creating a UNIQUE constraint and creating a unique index independent of a constraint. Enforcing a UNIQUE constraint will make the business rule/data integrity meaningful and thereby directing the objective of the UNIQUE index it creates.

    --Ramesh