Search notes:
SQL Server: Unique constraint
See also
sys.key_constraints
Type
UQ
in
sys.objects
Table constraints
Index