View unique constratints on the MySQL database

To view the unique constraints in MySQL database, use below queries
select * from information_schema.TABLE_CONSTRAINTS where CONSTRAINT_SCHEMA = '<dbName>' and constraint_type = 'UNIQUE';