TSQL - Find tables that is missing some kind of contraint

Post date: Jun 21, 2011 2:37:18 PM

SELECT *FROM INFORMATION_SCHEMA.tables iss LEFT OUTER JOIN sys.key_constraints ON iss.TABLE_NAME = OBJECT_NAME(parent_object_id) AND iss.TABLE_SCHEMA = SCHEMA_NAME(schema_id) AND type = 'UQ'WHERE name IS NULL ORDER BY TABLE_SCHEMA, TABLE_NAME