information_schema.tables
The information_schema.tables system table is a view that provides metadata about all tables across all databases, including their schema, type, engine, and creation details. It also includes storage metrics such as data length, index length, and row count, offering insights into table structure and usage.
system.build_options
This system table describes the build options of the current Databend release.
system.caches
An overview of various caches being managed in Databend.
system.clusters
Contains information about cluster nodes.
system.columns
Contains information about columns of tables.
system.configs
Contains information about Databend server configs.
system.contributors
Contains information about contributors.
system.credits
Contains information about credits.
system.databases_with_history
Records all databases, including active and dropped ones. It shows each database's catalog, name, unique ID, owner (if specified), and the deletion timestamp (NULL if still active).
system.databases
Provides metadata about all databases in the system, including their catalogs, names, unique IDs, owners, and drop timestamps.
system.functions
Contains information about the supported built-in scalar and aggregate.
system.indexes
Contains information about the created aggregating indexes.
system.locks
Contains information about the locks in the system.
system.metrics
Contains information about metric events.
system.numbers
This table contains a single UInt64 column named number that contains almost all the natural numbers starting from zero.
system.query_log
A read-only in-memory table stores all the query logs.
system.settings
Stores the system settings of the current session.
system.stream_status
Provides information about the status of a specified stream, yielding a single-column result (has_data) that can take on values of true or false:
system.streams
Provides information about streams in the system. Each row in this table corresponds to a stream, and the columns contain details such as the stream's mode, comment (if any), associated table name, table ID, table version, snapshot location, invalid reason (if applicable), and owner.
system.table_functions
Get all table functions' names.
system.tables_with_history
Provides metadata information for all tables, including historical tables. It includes details such as table properties, creation time, number of rows, data size, and more.
system.tables
Provides metadata information for all tables. It includes details such as table properties, creation time, number of rows, data size, and more.
system.temp_files
Contains information about temporary files created by Databend, such as spill files. To remove the temporary files, use the VACUUM TEMPORARY FILES command.
system.temporary_tables
Provides information about all existing temporary tables in the current session.
system.user_functions
Contains information about user-defined functions and external functions in the system.
system.virtual_columns
Contains information about the created virtual columns in the system.