database - How do I show unique constraints of a table in MySQL?

Question

I created them, but I forgot which ones they are.

I just want to

1. show them.
2. remove all the constraints on a table.

Answer 1

select distinct CONSTRAINT_NAME
from information_schema.TABLE_CONSTRAINTS
where table_name = 'table_name' and constraint_type = 'UNIQUE';