MySQL query tables, views, triggers, functions, stored procedures

1. mysql Queries all tables:

SELECT table_name from INFORMATION_SCHEMA. TABLES WHERE table_schema = ' database name ' and Table_type = ' base TABLE '

MySQL Query build Table statement:

Show create table ' table name '

2.mysql Querying all Views:

SELECT table_name from INFORMATION_SCHEMA. TABLES WHERE table_schema = ' database name ' and table_type = ' VIEW '

MySQL Query view creation statement:

Show CREATE view ' views Name '

3.mysql Query all functions:

SELECT name from Mysql.proc where db= ' ifms ' and type= ' function '

MySQL query function definition statement:

SHOW CREATE function ' name '

4.mysql querying all stored procedures:

SELECT name from Mysql.proc where db= ' ifms ' and type= ' procedure '

MySQL query procedure definition statement:

SHOW CREATE procedure ' Stored procedure name '

5.mysql query all triggers:

SELECT * from INFORMATION_SCHEMA. ' TRIGGERS '

MySQL query trigger definition statement:

SELECT * from information_schema.triggers where trigger_name= ' trigger name ';

Customize the SQL definition according to the information (no resources found ...). For help

MySQL query tables, views, triggers, functions, stored procedures