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.functions
Contains information about scalar, aggregate and user defined functions.
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.tracing
Contains information about server log.