获取所有的库

SELECT SCHEMA_NAME
FROM information_schema.SCHEMATA;

获取所有的表（可查询指定库的）

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = '<database_name>';

获取所有的视图

SELECT TABLE_NAME
FROM information_schema.VIEWS

获取索引信息

SELECT DISTINCT INDEX_NAME
FROM information_schema.STATISTICS

获取函数和存储过程信息

SELECT ROUTINE_NAME
FROM information_schema.ROUTINES

获取触发器信息

SELECT TRIGGER_NAME, EVENT_OBJECT_TABLE
FROM information_schema.TRIGGERS