[show create table]mysql.proc

 

CREATE TABLE `mysql`.`proc` (
  `db` varchar(64) DEFAULT NULL,
  `name` varchar(64) DEFAULT NULL,
  `type` enum('FUNCTION','PROCEDURE','PACKAGE', 'PACKAGE BODY'),
  `specific_name` varchar(64) DEFAULT NULL,
  `language` enum('SQL'),
  `sql_data_access` enum('CONTAINS_SQL', 'NO_SQL', 'READS_SQL_DATA', 'MODIFIES_SQL_DATA'),
  `is_deterministic` enum('YES','NO'),
  `security_type` enum('INVOKER','DEFINER'),
  `param_list` blob,
  `returns` longblob,
  `body` longblob,
  `definer` varchar(141),
  `created` timestamp,
  `modified` timestamp,
  `sql_mode` 	set('REAL_AS_FLOAT', 'PIPES_AS_CONCAT', 'ANSI_QUOTES', 'IGNORE_SPACE', 'IGNORE_BAD_TABLE_OPTIONS', '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', 'EMPTY_STRING_IS_NULL', 'SIMULTANEOUS_ASSIGNMENT'),
  `comment` text,
  `character_set_client` char(32),
  `collation_connection` 	char(32),
  `db_collation` 	char(32),
  `body_utf8` 	longblob,
  `aggregate` 	enum('NONE', 'GROUP')
)