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:
ALL_PLUGINS
APPLICABLE_ROLES
CHARACTER_SETS
CHECK_CONSTRAINTS
COLLATIONS
COLLATION_CHARACTER_SET_APPLICABILITY
COLUMNS
COLUMN_PRIVILEGES
ENABLED_ROLES
ENGINES
EVENTS
FILES
GLOBAL_STATUS
GLOBAL_VARIABLES
KEYWORDS
KEY_CACHES
KEY_COLUMN_USAGE
OPTIMIZER_TRACE
PARAMETERS
PARTITIONS
PLUGINS
PROCESSLIST
PROFILING
REFERENTIAL_CONSTRAINTS
ROUTINES
SCHEMATA
SCHEMA_PRIVILEGES
SESSION_STATUS
SESSION_VARIABLES
STATISTICS
SQL_FUNCTIONS
SYSTEM_VARIABLES
TABLES
TABLESPACES
TABLE_CONSTRAINTS
TABLE_PRIVILEGES
TRIGGERS
USER_PRIVILEGES
VIEWS
CLIENT_STATISTICS
INDEX_STATISTICS
INNODB_SYS_DATAFILES
GEOMETRY_COLUMNS
INNODB_SYS_TABLESTATS
SPATIAL_REF_SYS
INNODB_BUFFER_PAGE
INNODB_TRX
INNODB_CMP_PER_INDEX
INNODB_METRICS
INNODB_LOCK_WAITS
INNODB_CMP
THREAD_POOL_WAITS
INNODB_CMP_RESET
THREAD_POOL_QUEUES
TABLE_STATISTICS
INNODB_SYS_FIELDS
INNODB_BUFFER_PAGE_LRU
INNODB_LOCKS
INNODB_FT_INDEX_TABLE
INNODB_CMPMEM
THREAD_POOL_GROUPS
INNODB_CMP_PER_INDEX_RESET
INNODB_SYS_FOREIGN_COLS
INNODB_FT_INDEX_CACHE
INNODB_BUFFER_POOL_STATS
INNODB_FT_BEING_DELETED
INNODB_SYS_FOREIGN
INNODB_CMPMEM_RESET
INNODB_FT_DEFAULT_STOPWORD
INNODB_SYS_TABLES
INNODB_SYS_COLUMNS
INNODB_FT_CONFIG
USER_STATISTICS
INNODB_SYS_TABLESPACES
INNODB_SYS_VIRTUAL
INNODB_SYS_INDEXES
INNODB_SYS_SEMAPHORE_WAITS
INNODB_MUTEXES
user_variables
INNODB_TABLESPACES_ENCRYPTION
INNODB_FT_DELETED
THREAD_POOL_STATS
[Tools]
Database:
`information_schema`