Knowledge Walls
John Peter
Pune, Maharashtra, India
`INFORMATION_SCHEMA`.`ROUTINES` in INFORMATION_SCHEMA Db of MySQL
2127 Views
INFORMATION ROUTINES Table 
ROUTINES Table contains procedures and functions of all schemas. schema name, routine name, routine type, routine definition, definer, charset, created date and more.

Name of the Column Type Null
SPECIFIC_NAME  varchar(64)  NO
ROUTINE_CATALOG  varchar(512)  YES
ROUTINE_SCHEMA  varchar(64)  NO
ROUTINE_NAME  varchar(64)  NO
ROUTINE_TYPE  varchar(9)  NO
DTD_IDENTIFIER  varchar(64)  YES
ROUTINE_BODY  varchar(8)  NO
ROUTINE_DEFINITION  longtext  YES
EXTERNAL_NAME  varchar(64)  YES
EXTERNAL_LANGUAGE  varchar(64)  YES
PARAMETER_STYLE  varchar(8)  NO
IS_DETERMINISTIC  varchar(3)  NO
SQL_DATA_ACCESS  varchar(64)  NO
SQL_PATH  varchar(64)  YES
SECURITY_TYPE  varchar(7)  NO
CREATED  datetime  NO
LAST_ALTERED  datetime  NO
SQL_MODE  varchar(8192)  NO
ROUTINE_COMMENT  varchar(64)  NO
DEFINER  varchar(77)  NO
CHARACTER_SET_CLIENT  varchar(32)  NO
COLLATION_CONNECTION  varchar(32)  NO
DATABASE_COLLATION  varchar(32)  NO
Previous Topics
Previous lessons of current book.
INFORMATION_SCHEMA Db of MySQL
INFORMATION_SCHEMA Db of MySQL
Best Lessons of "MySQL"
Top lessons which are viewed more times.
  Copyright © 2014 Knowledge walls, All rights reserved
KnowledgeWalls
keep your tutorials and learnings with KnowledgeWalls. Don't lose your learnings hereafter. Save and revise it whenever required.
Click here for more details