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 VECTOR_INDEXES 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

_{This page is licensed: CC BY-SA / Gnu FDL}