SQL-Browser
[Tools]
Database:
`
information_schema
`
---
SHOW TABLE STATUS FROM `information_schema`
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:
Only Structure
Structure and Data
select table:
CHARACTER_SETS
COLLATIONS
COLLATION_CHARACTER_SET_APPLICABILITY
COLUMNS
COLUMN_PRIVILEGES
ENGINES
EVENTS
FILES
GLOBAL_STATUS
GLOBAL_VARIABLES
KEY_COLUMN_USAGE
OPTIMIZER_TRACE
PARAMETERS
PARTITIONS
PLUGINS
PROCESSLIST
PROFILING
REFERENTIAL_CONSTRAINTS
ROUTINES
SCHEMATA
SCHEMA_PRIVILEGES
SESSION_STATUS
SESSION_VARIABLES
STATISTICS
TABLES
TABLESPACES
TABLE_CONSTRAINTS
TABLE_PRIVILEGES
TRIGGERS
USER_PRIVILEGES
VIEWS
INNODB_LOCKS
INNODB_TRX
INNODB_SYS_DATAFILES
INNODB_LOCK_WAITS
INNODB_SYS_TABLESTATS
INNODB_CMP
INNODB_METRICS
INNODB_CMP_RESET
INNODB_CMP_PER_INDEX
INNODB_CMPMEM_RESET
INNODB_FT_DELETED
INNODB_BUFFER_PAGE_LRU
INNODB_SYS_FOREIGN
INNODB_SYS_COLUMNS
INNODB_SYS_INDEXES
INNODB_FT_DEFAULT_STOPWORD
INNODB_SYS_FIELDS
INNODB_CMP_PER_INDEX_RESET
INNODB_BUFFER_PAGE
INNODB_CMPMEM
INNODB_FT_INDEX_TABLE
INNODB_FT_BEING_DELETED
INNODB_SYS_TABLESPACES
INNODB_FT_INDEX_CACHE
INNODB_SYS_FOREIGN_COLS
INNODB_SYS_TABLES
INNODB_BUFFER_POOL_STATS
INNODB_FT_CONFIG
[Tools]
Database:
`information_schema`