查看表
- show tables
- 通过information_schema数据库中的tables视图查看,例如:select table_name from `tables` where table_schema=‘your_database’;
- show table status [like ‘your_table’] \G
- show create table table_name
查看视图
- show tables(包括表和视图)
- 通过information_schema数据库中的views视图查看,例如:select table_name from `views` where table_schema=‘your_database’;
- show table status [like ‘your_view’] \G
- show create view||table view_name
查看存储过程以及函数
- 通过information_schema数据库中的routines视图查看,例如:select routine_name from `routines` where routine_schema=‘your_database’;
- show procedure status like ‘you_procedure’ \G
- show function status like ‘you_function’ \G
- show create procedure||function name
查看触发器
- show triggers \G
- 通过information_schema数据库中的triggers视图查看,例如:select trigger_name from `triggers` where trigger_schema=‘your_database’;
- show create trigger name
查看调度器
- show events \G
- 通过information_schema数据库中的events视图查看,例如:select event_name from `events` where event_schema=‘your_database’;
- show create event name