1. 查找某一个数据库下的某个表的结构信息:
SELECT * FROM information_schema.tables WHERE table_schema='db_name' AND table_name = 'table_name' \G
如:
2.查看某个表上的触发器
SELECT * FROM information_schema.triggers WHERE trigger_schema='db_name' AND event_object_table='table_name' \G
或
SHOW TRIGGERS FROM db_name LIKE 'table_name' \G
3.查看某个数据库的存储过程或函数
SELECT * FROM mysql.proc WHERE db='db_name' AND type='function or procedure';
SELECT * FROM information_schema.routines WHERE routine_schema='db_name' AND routine_type='function or procedure';
或
SHOW PROCEDURE STATUS WHERE db='db_name';
SHOW FUNCTION STATUS WHERE db='db_name';
如: