The INFORMATION_SCHEMA ROUTINES Table : INFORMATION_SCHEMA « Data Dictionary « MySQL Tutorial






The ROUTINES table provides information about procedures and functions.

The column named "mysql.proc name" indicates the mysql.proc table column that corresponds to the INFORMATION_SCHEMA.ROUTINES table column, if any.

mysql> desc INFORMATION_SCHEMA.ROUTINES;
+--------------------+--------------+------+-----+---------------------+-------+
| Field              | Type         | Null | Key | Default             | Extra |
+--------------------+--------------+------+-----+---------------------+-------+
| SPECIFIC_NAME      | varchar(64)  | NO   |     |                     |       |
| ROUTINE_CATALOG    | varchar(512) | YES  |     | NULL                |       |
| ROUTINE_SCHEMA     | varchar(64)  | NO   |     |                     |       |
| ROUTINE_NAME       | varchar(64)  | NO   |     |                     |       |
| ROUTINE_TYPE       | varchar(9)   | NO   |     |                     |       |
| DTD_IDENTIFIER     | varchar(64)  | YES  |     | NULL                |       |
| ROUTINE_BODY       | varchar(8)   | NO   |     |                     |       |
| ROUTINE_DEFINITION | longtext     | YES  |     | NULL                |       |
| EXTERNAL_NAME      | varchar(64)  | YES  |     | NULL                |       |
| EXTERNAL_LANGUAGE  | varchar(64)  | YES  |     | NULL                |       |
| PARAMETER_STYLE    | varchar(8)   | NO   |     |                     |       |
| IS_DETERMINISTIC   | varchar(3)   | NO   |     |                     |       |
| SQL_DATA_ACCESS    | varchar(64)  | NO   |     |                     |       |
| SQL_PATH           | varchar(64)  | YES  |     | NULL                |       |
| SECURITY_TYPE      | varchar(7)   | NO   |     |                     |       |
| CREATED            | datetime     | NO   |     | 0000-00-00 00:00:00 |       |
| LAST_ALTERED       | datetime     | NO   |     | 0000-00-00 00:00:00 |       |
| SQL_MODE           | longtext     | NO   |     |                     |       |
| ROUTINE_COMMENT    | varchar(64)  | NO   |     |                     |       |
| DEFINER            | varchar(77)  | NO   |     |                     |       |
+--------------------+--------------+------+-----+---------------------+-------+
20 rows in set (0.02 sec)








25.8.INFORMATION_SCHEMA
25.8.1.The INFORMATION_SCHEMA Database
25.8.2.The INFORMATION_SCHEMA.SCHEMATA Table
25.8.3.The INFORMATION_SCHEMA.TABLES Table
25.8.4.The INFORMATION_SCHEMA.COLUMNS Table
25.8.5.The INFORMATION_SCHEMA.STATISTICS Table
25.8.6.The INFORMATION_SCHEMA.USER_PRIVILEGES Table
25.8.7.The INFORMATION_SCHEMA.SCHEMA_PRIVILEGES Table
25.8.8.The INFORMATION_SCHEMA.TABLE_PRIVILEGES Table
25.8.9.The INFORMATION_SCHEMA.COLUMN_PRIVILEGES Table
25.8.10.The INFORMATION_SCHEMA.CHARACTER_SETS Table
25.8.11.The INFORMATION_SCHEMA.COLLATIONS Table
25.8.12.The INFORMATION_SCHEMA.COLLATION_CHARACTER_SET_APPLICABILITY Table
25.8.13.The INFORMATION_SCHEMA.TABLE_CONSTRAINTS Table
25.8.14.The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table
25.8.15.The INFORMATION_SCHEMA ROUTINES Table
25.8.16.The INFORMATION_SCHEMA.VIEWS Table
25.8.17.The INFORMATION_SCHEMA.TRIGGERS Table
25.8.18.The INFORMATION_SCHEMA.PROFILING Table