xxxxxxxxxx
CREATE TABLE example (
id INT NOT NULL,
column1 INT,
column2 VARCHAR(255),
UNIQUE (column1)
);
xxxxxxxxxx
select distinct CONSTRAINT_NAME
from information_schema.TABLE_CONSTRAINTS
where table_name = 'TableName' and constraint_type = 'UNIQUE';