View unique constratints on the MySQL database April 03, 2018 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'; Read more