/*information_schema*/ /*字符集*/ SELECT * FROM information_schema.CHARACTER_SETS C; SELECT * FROM information_schema.COLLATION_CHARACTER_SET_APPLICABILITY C; SELECT * FROM information_schema.COLLATIONS C; /*不詳*/ SELECT * FROM information_schema.COLUMN_PRIVILEGES C; /*字段欄位*/ SELECT * FROM information_schema.`COLUMNS` C; /*引擎*/ SELECT * FROM information_schema.ENGINES E; /*事件*/ SELECT * FROM information_schema.`EVENTS` E; /*不詳*/ SELECT * FROM information_schema.FILES F; SELECT * FROM information_schema.GLOBAL_STATUS G; SELECT * FROM information_schema.GLOBAL_VARIABLES G; SELECT * FROM information_schema.KEY_COLUMN_USAGE K; SELECT * FROM information_schema.PARTITIONS P; /*引擎版本*/ SELECT * FROM information_schema.PLUGINS P; /*進程列表*/ SELECT * FROM information_schema.`PROCESSLIST` P; /*分析*/ SELECT * FROM information_schema.PROFILING P; /*約*束/*/ SELECT * FROM information_schema.REFERENTIAL_CONSTRAINTS R; /*PROCEDURE AND FUNCTION*/ SELECT * FROM information_schema.ROUTINES R; /*不詳細*/ SELECT * FROM information_schema.SCHEMA_PRIVILEGES S; /*DATABASE*/ SELECT * FROM information_schema.SCHEMATA S; /*會話狀態*/ SELECT * FROM information_schema.SESSION_STATUS S; /*會*話變量/*/ SELECT * FROM information_schema.SESSION_VARIABLES S; /*統計信息*/ SELECT * FROM information_schema.STATISTICS S; /*約*束/*/ SELECT * FROM information_schema.TABLE_CONSTRAINTS T; /*表的特權*/ SELECT * FROM information_schema.TABLE_PRIVILEGES T; /*表*/ SELECT * FROM information_schema.`TABLES` T; /*确發器*/ SELECT * FROM information_schema.TRIGGERS T; /*系統用戶權限*/ SELECT * FROM information_schema.USER_PRIVILEGES U; /*視圖*/ SELECT * FROM information_schema.VIEWS V;

官方資料: