SELECT * FROM information_schema.`TABLE_CONSTRAINTS` WHERE table_schema='dms' and CONSTRAINT_TYPE='UNIQUE';
select * from information_schema.KEY_COLUMN_USAGE;
SELECT t.CONSTRAINT_SCHEMA,t.TABLE_NAME,t.CONSTRAINT_NAME, t.CONSTRAINT_TYPE,t.ENFORCED,c.COLUMN_NAME
FROM information_schema.`TABLE_CONSTRAINTS` t
INNER JOIN information_schema.KEY_COLUMN_USAGE c
ON t.CONSTRAINT_name=c.CONSTRAINT_name AND t.CONSTRAINT_SCHEMA=c.CONSTRAINT_SCHEMA
WHERE t.TABLE_SCHEMA='dms'
AND CONSTRAINT_TYPE='UNIQUE';
SHOW TABLE STATUS FROM dbname LIKE 'tbname';
SHOW CREATE TABLE tbname;