SQL-Browser

[Tools]  Database: `information_schema`  Table: `ROUTINES`

   show less  show more             Upload SQL file   Search   MySQl Documentation
The execution of SQL Statements can manipulate data. TAKE CARE! The Authors don't accept any liability for damaged or lost data.

Tables of Database `information_schema` edit
create table:
copy table:
select table:     

 

Table `ROUTINES`
Table properties of `ROUTINES` (30 Fields)Name
Engine
Row Format
Charset
Collation
Comment
 

 

Fields of table `ROUTINES`
insert new field

 FieldTypeSizeNULLKeyAttributeDefaultExtraCollationComment
edit field  delete field  1.SPECIFIC_NAMEvarchar64noutf8_general_ci
edit field  delete field  2.ROUTINE_CATALOGvarchar512noutf8_general_ci
edit field  delete field  3.ROUTINE_SCHEMAvarchar64noutf8_general_ci
edit field  delete field  4.ROUTINE_NAMEvarchar64noutf8_general_ci
edit field  delete field  5.ROUTINE_TYPEvarchar9noutf8_general_ci
edit field  delete field  6.DATA_TYPEvarchar64noutf8_general_ci
edit field  delete field  7.CHARACTER_MAXIMUM_LENGTHint21yes
edit field  delete field  8.CHARACTER_OCTET_LENGTHint21yes
edit field  delete field  9.NUMERIC_PRECISIONint21yes
edit field  delete field  10.NUMERIC_SCALEint21yes
edit field  delete field  11.CHARACTER_SET_NAMEvarchar64yesutf8_general_ci
edit field  delete field  12.COLLATION_NAMEvarchar64yesutf8_general_ci
edit field  delete field  13.DTD_IDENTIFIERlongtextyesutf8_general_ci
edit field  delete field  14.ROUTINE_BODYvarchar8noutf8_general_ci
edit field  delete field  15.ROUTINE_DEFINITIONlongtextyesutf8_general_ci
edit field  delete field  16.EXTERNAL_NAMEvarchar64yesutf8_general_ci
edit field  delete field  17.EXTERNAL_LANGUAGEvarchar64yesutf8_general_ci
edit field  delete field  18.PARAMETER_STYLEvarchar8noutf8_general_ci
edit field  delete field  19.IS_DETERMINISTICvarchar3noutf8_general_ci
edit field  delete field  20.SQL_DATA_ACCESSvarchar64noutf8_general_ci
edit field  delete field  21.SQL_PATHvarchar64yesutf8_general_ci
edit field  delete field  22.SECURITY_TYPEvarchar7noutf8_general_ci
edit field  delete field  23.CREATEDdatetimeno0000-00-00 00:00:00
edit field  delete field  24.LAST_ALTEREDdatetimeno0000-00-00 00:00:00
edit field  delete field  25.SQL_MODEvarchar8192noutf8_general_ci
edit field  delete field  26.ROUTINE_COMMENTlongtextnoutf8_general_ci
edit field  delete field  27.DEFINERvarchar77noutf8_general_ci
edit field  delete field  28.CHARACTER_SET_CLIENTvarchar32noutf8_general_ci
edit field  delete field  29.COLLATION_CONNECTIONvarchar32noutf8_general_ci
edit field  delete field  30.DATABASE_COLLATIONvarchar32noutf8_general_ci

Indexes of table `ROUTINES`
  Name Columns Size Type Duplicates allowed Cardinality Comment
No Indexes in Table