MySQL 查询数据库所有表视图存储过程触发器的定义语句

1、查询数据库所有表

use mysql;show tables;
select table_name from information_schema.tables where table_schema = '数据库名' and table_type = 'base table'

2、查询数据库所有视图

select table_name from information_schema.tables where table_schema = '数据库名' and table_type ='view'

3、查询数据库所有存储过程

show procedure status where Db = 'uu898steam';
select name from mysql.proc where db = '数据库名' and type = 'procedure';
select `name` from mysql.proc where db = '数据库名' and `type` = 'procedure';

4、查询数据库所有触发器

select  *  from information_schema.`triggers`
SELECT  *  FROM information_schema.`TRIGGERS`

5、查询函数创建语句

show create function func_name;

6、查询存储过程定义语句

show create procedure sp_test;
show create procedure sp_checkalluserfunds;

7、查询触发器定义语句

select * from information_schema.triggers where trigger_name='触发器名';

8、history

-- test

desc mysql.proc;
select * from mysql.proc;
select name from mysql.proc where db = 'uu898steam' and type  ='procedure'
select `name` from mysql.proc where db = 'uu898steam' and `type` = 'function';
 
desc mysql.func;
select * from mysql.func;
select `name` from mysql.func where  `type` = 'function';
select `name` from mysql.func where  `type` = 'aggregate';