SDU Tools 147 List SQL Server Constraints With System Names
SDU Tools are free tools and example T-SQL code for SQL Server developers and DBAs. When creating constraints in SQL Server, the default is that the system will create a name for a constraint if you do not provide one. You should always provide a name. This is more important in SQL Server than in some other databases. This tool locates any constraints that were system-named, so that you can rename or recreate them with useful names.
To join SDU Insiders and get all our free resources, including SDU Tools, see the details at http://sdutools.sqldownunder.com