| Column | Type | Null | Default | Links to | Comments |
|---|---|---|---|---|---|
| SPECIFIC_NAME | varchar(64) | No | |||
| ROUTINE_CATALOG | varchar(512) | No | |||
| ROUTINE_SCHEMA | varchar(64) | No | SCHEMATA -> SCHEMA_NAME | ||
| ROUTINE_NAME | varchar(64) | No | |||
| ROUTINE_TYPE | varchar(9) | No | |||
| DATA_TYPE | varchar(64) | No | |||
| CHARACTER_MAXIMUM_LENGTH | int(21) | Yes | NULL | ||
| CHARACTER_OCTET_LENGTH | int(21) | Yes | NULL | ||
| NUMERIC_PRECISION | bigint(21) | Yes | NULL | ||
| NUMERIC_SCALE | int(21) | Yes | NULL | ||
| DATETIME_PRECISION | bigint(21) | Yes | NULL | ||
| CHARACTER_SET_NAME | varchar(64) | Yes | NULL | CHARACTER_SETS -> CHARACTER_SET_NAME | |
| COLLATION_NAME | varchar(64) | Yes | NULL | COLLATIONS -> COLLATION_NAME | |
| DTD_IDENTIFIER | longtext | 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 | varchar(8192) | No | |||
| ROUTINE_COMMENT | longtext | No | |||
| DEFINER | varchar(77) | No | |||
| CHARACTER_SET_CLIENT | varchar(32) | No | CHARACTER_SETS -> CHARACTER_SET_NAME | ||
| COLLATION_CONNECTION | varchar(32) | No | COLLATIONS -> COLLATION_NAME | ||
| DATABASE_COLLATION | varchar(32) | No | COLLATIONS -> COLLATION_NAME |