Webinar | The Great Database Exodus: Navigating Strategic Risk in the Post-Oracle MySQL Era

Ctrlk

Download MariaDB Contact Us

Information Schema Tables

Query information_schema.tables in MariaDB Server. These system tables provides metadata about all tables in the databases, including their names, types, storage engines, and other crucial properties.

Information Schema ALL_PLUGINS Table Information Schema APPLICABLE_ROLES Table Information Schema CATALOG Table Information Schema CHARACTER_SETS Table Information Schema CHECK_CONSTRAINTS Table Information Schema CLIENT_STATISTICS Table Information Schema COLLATION_CHARACTER_SET_APPLICABILITY Table Information Schema COLLATIONS Table Information Schema COLUMN_PRIVILEGES Table Information Schema COLUMNS Table Information Schema DISKS Table Information Schema ENABLED_ROLES Table Information Schema ENGINES Table Information Schema EVENTS Table Information Schema FEEDBACK Table Information Schema FILE_KEY_MANAGEMENT_KEYS Table Information Schema HASHICORP_KEY_MANAGEMENT_CACHE Table Information Schema GEOMETRY_COLUMNS Table Information Schema GLOBAL_STATUS and SESSION_STATUS Tables Information Schema GLOBAL_VARIABLES and SESSION_VARIABLES Tables Information Schema INDEX_STATISTICS Table Information Schema KEY_CACHES Table Information Schema KEY_COLUMN_USAGE Table Information Schema KEY_PERIOD_USAGE Table Information Schema KEYWORDS Table Information Schema LOCALES Table Information Schema METADATA_LOCK_INFO Table Information Schema MROONGA_STATS Table Information Schema OPTIMIZER_TRACE Table Information Schema PARAMETERS Table Information Schema PARTITIONS Table Information Schema PERIODS Table Information Schema PLUGINS Table Information Schema PROCESSLIST Table Information Schema PROFILING Table Information Schema QUERY_CACHE_INFO Table Information Schema QUERY_RESPONSE_TIME Table Information Schema REFERENTIAL_CONSTRAINTS Table Information Schema ROUTINES Table Information Schema SCHEMA_PRIVILEGES Table Information Schema SCHEMATA Table Information Schema SEQUENCES Table Information Schema SLAVE_STATUS Table Information Schema SPATIAL_REF_SYS Table Information Schema SPIDER_ALLOC_MEM Table Information Schema SQL_FUNCTIONS Table Information Schema STATISTICS Table Information Schema SYSTEM_VARIABLES Table Information Schema TABLE_CONSTRAINTS Table Information Schema TABLE_PRIVILEGES Table Information Schema TABLE_STATISTICS Table Information Schema TABLES Table Information Schema TABLESPACES Table Information Schema THREAD_POOL_GROUPS Table Information Schema THREAD_POOL_QUEUES Table Information Schema THREAD_POOL_STATS Table Information Schema THREAD_POOL_WAITS Table Information Schema TRIGGERED_UPDATE_COLUMNS Information Schema TRIGGERS Table Information Schema USER_PRIVILEGES Table Information Schema USER_STATISTICS Table Information Schema USER_VARIABLES Table Information Schema USERS Table Information Schema WSREP_BF_ABORTS Information Schema WSREP_CERT_KEYS Information Schema WSREP_CERT_KEYS_HISTORY Information Schema WSREP_CONNECTIONS Information Schema WSREP_MEMBERSHIP Table Information Schema WSREP_STATUS Table Information Schema WSREP_THD_STATE Information Schema WSREP_THD_STATE_HISTORY Information Schema InnoDB Tables Information Schema MyRocks Tables Information Schema XtraDB Tables

PreviousTIME_MS column in INFORMATION_SCHEMA.PROCESSLIST NextInformation Schema ALL_PLUGINS Table

Last updated 8 months ago

Was this helpful?