Column | Type | Null | Default | Links to | Comments |
---|---|---|---|---|---|
SPECIFIC_CATALOG | varchar(512) | No | |||
SPECIFIC_SCHEMA | varchar(64) | No | SCHEMATA -> SCHEMA_NAME | ||
SPECIFIC_NAME | varchar(64) | No | |||
ORDINAL_POSITION | int(21) | No | 0 | ||
PARAMETER_MODE | varchar(5) | Yes | NULL | ||
PARAMETER_NAME | varchar(64) | Yes | NULL | ||
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 | No | |||
ROUTINE_TYPE | varchar(9) | No |