Home Forums SQL Server 2008 T-SQL (SS2K8) how to find duplicate default constraints in sql server RE: how to find duplicate default constraints in sql server

  • September 17, 2012 at 8:33 am

    #1538641

    Check this query:

    SELECT CONSTRAINT_NAME, COUNT(*) FROM INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE

    GROUP BY CONSTRAINT_NAME

    HAVING COUNT(*) > 1