SQL-Browser

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

   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.

Data View

new record    Edit table structure

Table `information_schema`.`S`
records 1 - 30 from totally 51    <<    <    >    >>

View: compact   The Query contains 21 Columns
 # TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE ENGINE VERSION ROW_FORMAT TABLE_ROWS AVG_ROW_LENGTH DATA_LENGTH MAX_DATA_LENGTH INDEX_LENGTH DATA_FREE AUTO_INCREMENT CREATE_TIME UPDATE_TIME CHECK_TIME TABLE_COLLATION CHECKSUM CREATE_OPTIONS TABLE_COMMENT
  edit delete1. 
def
information_schema
CHARACTER_SETS
SYSTEM VIEW
MEMORY
10
Fixed
NULL
384
0
16434816
0
0
NULL
2020-10-31 14:06:30
NULL
NULL
utf8_general_ci
NULL
max_rows=43690
  edit delete2. 
def
information_schema
COLLATIONS
SYSTEM VIEW
MEMORY
10
Fixed
NULL
231
0
16704765
0
0
NULL
2020-10-31 14:06:30
NULL
NULL
utf8_general_ci
NULL
max_rows=72628
  edit delete3. 
def
information_schema
COLLATION_CHARACTER_SET_APPLICABILITY
SYSTEM VIEW
MEMORY
10
Fixed
NULL
195
0
16357770
0
0
NULL
2020-10-31 14:06:30
NULL
NULL
utf8_general_ci
NULL
max_rows=86037
  edit delete4. 
def
information_schema
COLUMNS
SYSTEM VIEW
MyISAM
10
Dynamic
NULL
0
0
281474976710655
1024
0
NULL
2020-10-31 14:06:30
2020-10-31 14:06:30
NULL
utf8_general_ci
NULL
max_rows=2802
  edit delete5. 
def
information_schema
COLUMN_PRIVILEGES
SYSTEM VIEW
MEMORY
10
Fixed
NULL
2565
0
16757145
0
0
NULL
2020-10-31 14:06:30
NULL
NULL
utf8_general_ci
NULL
max_rows=6540
  edit delete6. 
def
information_schema
ENGINES
SYSTEM VIEW
MEMORY
10
Fixed
NULL
490
0
16574250
0
0
NULL
2020-10-31 14:06:30
NULL
NULL
utf8_general_ci
NULL
max_rows=34239
  edit delete7. 
def
information_schema
EVENTS
SYSTEM VIEW
MyISAM
10
Dynamic
NULL
0
0
281474976710655
1024
0
NULL
2020-10-31 14:06:30
2020-10-31 14:06:30
NULL
utf8_general_ci
NULL
max_rows=618
  edit delete8. 
def
information_schema
FILES
SYSTEM VIEW
MEMORY
10
Fixed
NULL
2677
0
16758020
0
0
NULL
2020-10-31 14:06:30
NULL
NULL
utf8_general_ci
NULL
max_rows=6267
  edit delete9. 
def
information_schema
GLOBAL_STATUS
SYSTEM VIEW
MEMORY
10
Fixed
NULL
3268
0
16755036
0
0
NULL
2020-10-31 14:06:30
NULL
NULL
utf8_general_ci
NULL
max_rows=5133
  edit delete10. 
def
information_schema
GLOBAL_VARIABLES
SYSTEM VIEW
MEMORY
10
Fixed
NULL
3268
0
16755036
0
0
NULL
2020-10-31 14:06:30
NULL
NULL
utf8_general_ci
NULL
max_rows=5133
  edit delete11. 
def
information_schema
KEY_COLUMN_USAGE
SYSTEM VIEW
MEMORY
10
Fixed
NULL
4637
0
16762755
0
0
NULL
2020-10-31 14:06:30
NULL
NULL
utf8_general_ci
NULL
max_rows=3618
  edit delete12. 
def
information_schema
PARAMETERS
SYSTEM VIEW
MyISAM
10
Dynamic
NULL
0
0
281474976710655
1024
0
NULL
2020-10-31 14:06:30
2020-10-31 14:06:30
NULL
utf8_general_ci
NULL
max_rows=6050
  edit delete13. 
def
information_schema
PARTITIONS
SYSTEM VIEW
MyISAM
10
Dynamic
NULL
0
0
281474976710655
1024
0
NULL
2020-10-31 14:06:30
2020-10-31 14:06:30
NULL
utf8_general_ci
NULL
max_rows=5579
  edit delete14. 
def
information_schema
PLUGINS
SYSTEM VIEW
MyISAM
10
Dynamic
NULL
0
0
281474976710655
1024
0
NULL
2020-10-31 14:06:30
2020-10-31 14:06:30
NULL
utf8_general_ci
NULL
max_rows=11328
  edit delete15. 
def
information_schema
PROCESSLIST
SYSTEM VIEW
MyISAM
10
Dynamic
NULL
0
0
281474976710655
1024
0
NULL
2020-10-31 14:06:30
2020-10-31 14:06:30
NULL
utf8_general_ci
NULL
max_rows=23899
  edit delete16. 
def
information_schema
PROFILING
SYSTEM VIEW
MEMORY
10
Fixed
NULL
308
0
16562084
0
0
NULL
2020-10-31 14:06:30
NULL
NULL
utf8_general_ci
NULL
max_rows=54471
  edit delete17. 
def
information_schema
REFERENTIAL_CONSTRAINTS
SYSTEM VIEW
MEMORY
10
Fixed
NULL
4814
0
16767162
0
0
NULL
2020-10-31 14:06:30
NULL
NULL
utf8_general_ci
NULL
max_rows=3485
  edit delete18. 
def
information_schema
ROUTINES
SYSTEM VIEW
MyISAM
10
Dynamic
NULL
0
0
281474976710655
1024
0
NULL
2020-10-31 14:06:30
2020-10-31 14:06:30
NULL
utf8_general_ci
NULL
max_rows=583
  edit delete19. 
def
information_schema
SCHEMATA
SYSTEM VIEW
MEMORY
10
Fixed
NULL
3464
0
16738048
0
0
NULL
2020-10-31 14:06:30
NULL
NULL
utf8_general_ci
NULL
max_rows=4843
  edit delete20. 
def
information_schema
SCHEMA_PRIVILEGES
SYSTEM VIEW
MEMORY
10
Fixed
NULL
2179
0
16736899
0
0
NULL
2020-10-31 14:06:30
NULL
NULL
utf8_general_ci
NULL
max_rows=7699
  edit delete21. 
def
information_schema
SESSION_STATUS
SYSTEM VIEW
MEMORY
10
Fixed
NULL
3268
0
16755036
0
0
NULL
2020-10-31 14:06:30
NULL
NULL
utf8_general_ci
NULL
max_rows=5133
  edit delete22. 
def
information_schema
SESSION_VARIABLES
SYSTEM VIEW
MEMORY
10
Fixed
NULL
3268
0
16755036
0
0
NULL
2020-10-31 14:06:30
NULL
NULL
utf8_general_ci
NULL
max_rows=5133
  edit delete23. 
def
information_schema
STATISTICS
SYSTEM VIEW
MEMORY
10
Fixed
NULL
5753
0
16752736
0
0
NULL
2020-10-31 14:06:30
NULL
NULL
utf8_general_ci
NULL
max_rows=2916
  edit delete24. 
def
information_schema
TABLES
SYSTEM VIEW
MEMORY
10
Fixed
NULL
9450
0
16764300
0
0
NULL
2020-10-31 14:06:30
NULL
NULL
utf8_general_ci
NULL
max_rows=1775
  edit delete25. 
def
information_schema
TABLESPACES
SYSTEM VIEW
MEMORY
10
Fixed
NULL
6951
0
16772763
0
0
NULL
2020-10-31 14:06:30
NULL
NULL
utf8_general_ci
NULL
max_rows=2413
  edit delete26. 
def
information_schema
TABLE_CONSTRAINTS
SYSTEM VIEW
MEMORY
10
Fixed
NULL
2504
0
16721712
0
0
NULL
2020-10-31 14:06:30
NULL
NULL
utf8_general_ci
NULL
max_rows=6700
  edit delete27. 
def
information_schema
TABLE_PRIVILEGES
SYSTEM VIEW
MEMORY
10
Fixed
NULL
2372
0
16748692
0
0
NULL
2020-10-31 14:06:30
NULL
NULL
utf8_general_ci
NULL
max_rows=7073
  edit delete28. 
def
information_schema
TRIGGERS
SYSTEM VIEW
MyISAM
10
Dynamic
NULL
0
0
281474976710655
1024
0
NULL
2020-10-31 14:06:30
2020-10-31 14:06:30
NULL
utf8_general_ci
NULL
max_rows=569
  edit delete29. 
def
information_schema
USER_PRIVILEGES
SYSTEM VIEW
MEMORY
10
Fixed
NULL
1986
0
16726092
0
0
NULL
2020-10-31 14:06:30
NULL
NULL
utf8_general_ci
NULL
max_rows=8447
  edit delete30. 
def
information_schema
VIEWS
SYSTEM VIEW
MyISAM
10
Dynamic
NULL
0
0
281474976710655
1024
0
NULL
2020-10-31 14:06:30
2020-10-31 14:06:30
NULL
utf8_general_ci
NULL
max_rows=6935

records 1 - 30 from totally 51    <<    <    >    >>