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 |