查看索引：
select * FROM information_schema.TABLE_CONSTRAINTS ;select * FROM information_schema.TABLE_CONSTRAINTS WHERE TABLE_NAME=‘table_name’ ;
查看表信息：
show create table table_name;
查看触发器：
SELECT * FROM information_schema.`TRIGGERS`;
本文共 288 字，大约阅读时间需要 1 分钟。
查看索引：
select * FROM information_schema.TABLE_CONSTRAINTS ;select * FROM information_schema.TABLE_CONSTRAINTS WHERE TABLE_NAME=‘table_name’ ;
查看表信息：
show create table table_name;
查看触发器：
SELECT * FROM information_schema.`TRIGGERS`;
转载于:https://www.cnblogs.com/drizzlewithwind/p/5710430.html