查询 information_schema 数据库中，tables 表中的信息：#######################

1. mysql 查询所有表:
   
   MariaDB [myclass]>
   
   SELECT TABLE_NAME FROM information_schema.tables WHERE table_schema= ‘myclass’ AND TABLE_TYPE=‘BASE TABLE’

show tables status; ##来源

2.mysql查询所有视图:

MariaDB [myclass]>SELECT TABLE_SCHEMA,TABLE_NAME FROM information_schema.VIEWS where TABLE_SCHEMA!=“sys”;

mysql查询视图创建语句: show create view

视图名


3.mysql 查询 自定义的 所有函数，和存储过程

SELECT SPECIFIC_NAME,ROUTINE_SCHEMA,ROUTINE_TYPE from information_schema.

ROUTINES

where ROUTINE_SCHEMA!=“sys”;

5.mysql查询所有触发器:

MariaDB [myclass]> show triggers \G

MariaDB [myclass]>SELECT TRIGGER_NAME,TRIGGER_SCHEMA from information_schema.

TRIGGERS

where TRIGGER_SCHEMA!=“sys”;

常用对象查询脚本

mysql -uroot <<EOF
use information_schema;
system echo &#