ROUTINES

mmt
FieldTypeNullKeyDefaultExtra
SPECIFIC_NAME varchar(64) NO
ROUTINE_CATALOG varchar(64) NO
ROUTINE_SCHEMA varchar(64) NO
ROUTINE_NAME varchar(64) NO
ROUTINE_TYPE enum('FUNCTION','PROCEDURE') NO
DATA_TYPE longtext YES
CHARACTER_MAXIMUM_LENGTH bigint(21) YES
CHARACTER_OCTET_LENGTH bigint(21) YES
NUMERIC_PRECISION int(10) unsigned YES
NUMERIC_SCALE int(10) unsigned YES
DATETIME_PRECISION int(10) unsigned YES
CHARACTER_SET_NAME varchar(64) YES
COLLATION_NAME varchar(64) YES
DTD_IDENTIFIER longtext YES
ROUTINE_BODY varchar(3) NO
ROUTINE_DEFINITION longtext YES
EXTERNAL_NAME binary(0) YES
EXTERNAL_LANGUAGE binary(0) YES
PARAMETER_STYLE varchar(3) NO
IS_DETERMINISTIC varchar(3) NO
SQL_DATA_ACCESS enum('CONTAINS SQL','NO SQL','READS SQL DATA','MODIFIES SQL DATA') NO
SQL_PATH binary(0) YES
SECURITY_TYPE enum('DEFAULT','INVOKER','DEFINER') NO
CREATED timestamp NO CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
LAST_ALTERED timestamp NO CURRENT_TIMESTAMP
SQL_MODE set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH','TIME_TRUNCATE_FRACTIONAL') NO
ROUTINE_COMMENT text NO
DEFINER varchar(93) NO
CHARACTER_SET_CLIENT varchar(64) NO
COLLATION_CONNECTION varchar(64) NO
DATABASE_COLLATION varchar(64) NO
[ START ][ Connect ] [ create table form ]

MySQL Nippon Association