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