查看索引:
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`;
查看索引:
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`;