SQL Server: sys.key_constraints

sys.key_constraints lists primary key and unique constraints (somewhat similar to where sys.objects where type in ('PK', 'UQ'))