Get all constraints of a specific type

select *

from information_schema.table_constraints

where CONSTRAINT_TYPE = 'UNIQUE' 

                -- 'CHECK' , 'UNIQUE' , 'PRIMARY KEY' , 'FOREIGN KEY'