# Materialize Documentation: SQL and catalog reference > Pages in the SQL and catalog reference section of the Materialize Documentation. Every link below points at the Markdown source of a documentation page. For the HTML page instead, drop `markdown-docs/` from the URL and drop the trailing `index.md`. - [SQL commands](https://materialize.com/docs/markdown-docs/sql/index.md): SQL commands reference. - [ALTER CLUSTER REPLICA](https://materialize.com/docs/markdown-docs/sql/alter-cluster-replica/index.md): `ALTER CLUSTER REPLICA` changes properties of a cluster replica. - [ALTER CLUSTER](https://materialize.com/docs/markdown-docs/sql/alter-cluster/index.md): `ALTER CLUSTER` changes the configuration of a cluster. - [ALTER CONNECTION](https://materialize.com/docs/markdown-docs/sql/alter-connection/index.md): `ALTER CONNECTION` allows you to modify the value of connection options; rotate secrets associated with connections; rename a connection; and change owner of a connection. - [ALTER DATABASE](https://materialize.com/docs/markdown-docs/sql/alter-database/index.md): `ALTER DATABASE` changes properties of a database. - [ALTER DEFAULT PRIVILEGES](https://materialize.com/docs/markdown-docs/sql/alter-default-privileges/index.md): `ALTER DEFAULT PRIVILEGES` defines default privileges that will be applied to objects created in the future. - [ALTER INDEX](https://materialize.com/docs/markdown-docs/sql/alter-index/index.md): `ALTER INDEX` changes the parameters of an index. - [ALTER MATERIALIZED VIEW](https://materialize.com/docs/markdown-docs/sql/alter-materialized-view/index.md): `ALTER MATERIALIZED VIEW` changes the parameters of a materialized view. - [ALTER NETWORK POLICY (Cloud)](https://materialize.com/docs/markdown-docs/sql/alter-network-policy/index.md): `ALTER NETWORK POLICY` alters an existing network policy. - [ALTER ROLE](https://materialize.com/docs/markdown-docs/sql/alter-role/index.md): `ALTER ROLE` alters the attributes of an existing role. - [ALTER SCHEMA](https://materialize.com/docs/markdown-docs/sql/alter-schema/index.md): `ALTER SCHEMA` change properties of a schema - [ALTER SECRET](https://materialize.com/docs/markdown-docs/sql/alter-secret/index.md): `ALTER SECRET` changes the contents of a secret. - [ALTER SINK](https://materialize.com/docs/markdown-docs/sql/alter-sink/index.md): `ALTER SINK` allows cutting a sink over to a new upstream relation without causing disruption to downstream consumers. - [ALTER SOURCE](https://materialize.com/docs/markdown-docs/sql/alter-source/index.md): `ALTER SOURCE` changes certain characteristics of a source. - [ALTER SYSTEM RESET](https://materialize.com/docs/markdown-docs/sql/alter-system-reset/index.md): Globally reset a configuration parameter to its default value. - [ALTER SYSTEM SET](https://materialize.com/docs/markdown-docs/sql/alter-system-set/index.md): `ALTER SYSTEM SET` globally modifies the value of a configuration parameter. - [ALTER TABLE](https://materialize.com/docs/markdown-docs/sql/alter-table/index.md): `ALTER TABLE` changes properties of a table. - [ALTER TYPE](https://materialize.com/docs/markdown-docs/sql/alter-type/index.md): `ALTER TYPE` changes properties of a type. - [ALTER VIEW](https://materialize.com/docs/markdown-docs/sql/alter-view/index.md): `ALTER VIEW` changes properties of a view. - [BEGIN](https://materialize.com/docs/markdown-docs/sql/begin/index.md): `BEGIN` starts a transaction block. - [CLOSE](https://materialize.com/docs/markdown-docs/sql/close/index.md): `CLOSE` closes a cursor. - [COMMENT ON](https://materialize.com/docs/markdown-docs/sql/comment-on/index.md): `COMMENT ON` adds or updates the comment of an object. - [COMMIT](https://materialize.com/docs/markdown-docs/sql/commit/index.md): `COMMIT` ends a transaction block and commits all changes if the transaction statements succeed. - [COPY FROM](https://materialize.com/docs/markdown-docs/sql/copy-from/index.md): `COPY FROM` copies data into a table using the COPY protocol. - [COPY TO](https://materialize.com/docs/markdown-docs/sql/copy-to/index.md): `COPY TO` outputs results from Materialize to standard output or object storage. - [CREATE CLUSTER REPLICA](https://materialize.com/docs/markdown-docs/sql/create-cluster-replica/index.md): `CREATE CLUSTER REPLICA` provisions a new replica of a cluster. - [CREATE CLUSTER](https://materialize.com/docs/markdown-docs/sql/create-cluster/index.md): `CREATE CLUSTER` creates a new cluster. - [CREATE CONNECTION](https://materialize.com/docs/markdown-docs/sql/create-connection/index.md): `CREATE CONNECTION` describes how to connect and authenticate to an external system in Materialize - [CREATE DATABASE](https://materialize.com/docs/markdown-docs/sql/create-database/index.md): `CREATE DATABASE` creates a new database. - [CREATE INDEX](https://materialize.com/docs/markdown-docs/sql/create-index/index.md): `CREATE INDEX` creates an in-memory index on a source, view, or materialized view. - [CREATE MATERIALIZED VIEW](https://materialize.com/docs/markdown-docs/sql/create-materialized-view/index.md): `CREATE MATERIALIZED VIEW` defines a view that is persisted in durable storage and incrementally updated as new data arrives. - [CREATE NETWORK POLICY (Cloud)](https://materialize.com/docs/markdown-docs/sql/create-network-policy/index.md): `CREATE NETWORK POLICY` creates a network policy that restricts access to a Materialize Cloud region using IP-based rules. - [CREATE ROLE](https://materialize.com/docs/markdown-docs/sql/create-role/index.md): `CREATE ROLE` creates a new role. - [CREATE SCHEMA](https://materialize.com/docs/markdown-docs/sql/create-schema/index.md): `CREATE SCHEMA` creates a new schema. - [CREATE SECRET](https://materialize.com/docs/markdown-docs/sql/create-secret/index.md): `CREATE SECRET` securely stores credentials in Materialize's secret management system. - [CREATE SINK](https://materialize.com/docs/markdown-docs/sql/create-sink/index.md): `CREATE SINK` connects Materialize to an external data sink. - [CREATE SINK: Iceberg](https://materialize.com/docs/markdown-docs/sql/create-sink/iceberg/index.md): Connecting Materialize to an Apache Iceberg table - [CREATE SINK: Kafka/Redpanda](https://materialize.com/docs/markdown-docs/sql/create-sink/kafka/index.md): Connecting Materialize to a Kafka or Redpanda broker sink - [CREATE SOURCE](https://materialize.com/docs/markdown-docs/sql/create-source/index.md): `CREATE SOURCE` connects Materialize to an external data source. - [CREATE SOURCE: Kafka/Redpanda (New Syntax)](https://materialize.com/docs/markdown-docs/sql/create-source/kafka-v2/index.md): Connecting Materialize to a Kafka or Redpanda broker using the new source syntax - [CREATE SOURCE: Kafka/Redpanda (Legacy Syntax)](https://materialize.com/docs/markdown-docs/sql/create-source/kafka/index.md): Connecting Materialize to a Kafka or Redpanda broker - [Appendix: Load generator](https://materialize.com/docs/markdown-docs/sql/create-source/load-generator/index.md): Using Materialize's built-in load generators - [CREATE SOURCE: MySQL (New Syntax)](https://materialize.com/docs/markdown-docs/sql/create-source/mysql-v2/index.md): Connecting Materialize to a MySQL database for Change Data Capture (CDC). - [CREATE SOURCE: MySQL (Legacy syntax)](https://materialize.com/docs/markdown-docs/sql/create-source/mysql/index.md): Connecting Materialize to a MySQL database for Change Data Capture (CDC). - [CREATE SOURCE: PostgreSQL (New Syntax)](https://materialize.com/docs/markdown-docs/sql/create-source/postgres-v2/index.md): Creates a new source from PostgreSQL 11+. - [CREATE SOURCE: PostgreSQL (Legacy Syntax)](https://materialize.com/docs/markdown-docs/sql/create-source/postgres/index.md): Connecting Materialize to a PostgreSQL database for Change Data Capture (CDC). - [CREATE SOURCE: SQL Server](https://materialize.com/docs/markdown-docs/sql/create-source/sql-server-v2/index.md): Connecting Materialize to a SQL Server database for Change Data Capture (CDC). - [CREATE SOURCE: SQL Server (Legacy Syntax)](https://materialize.com/docs/markdown-docs/sql/create-source/sql-server/index.md): Connecting Materialize to a SQL Server database for Change Data Capture (CDC). - [CREATE SOURCE: Webhook](https://materialize.com/docs/markdown-docs/sql/create-source/webhook/index.md): Ingesting data into Materialize with HTTP requests - [CREATE TABLE](https://materialize.com/docs/markdown-docs/sql/create-table/index.md): `CREATE TABLE` creates a table that is persisted in durable storage. - [CREATE TABLE: Kafka source table](https://materialize.com/docs/markdown-docs/sql/create-table/kafka/index.md): Create a read-only table from a Kafka/Redpanda source (new syntax). - [CREATE TABLE: MySQL source table](https://materialize.com/docs/markdown-docs/sql/create-table/mysql/index.md): Create a read-only table from a MySQL source (new syntax). - [CREATE TABLE: PostgreSQL source table](https://materialize.com/docs/markdown-docs/sql/create-table/postgres/index.md): Create a read-only table from a PostgreSQL source (new syntax). - [CREATE TABLE: SQL Server source table](https://materialize.com/docs/markdown-docs/sql/create-table/sql-server/index.md): Create a read-only table from a SQL Server source (new syntax). - [CREATE TABLE: Read-write table](https://materialize.com/docs/markdown-docs/sql/create-table/user-populated/index.md): Create a read-write, user-populated table in Materialize. - [CREATE TYPE](https://materialize.com/docs/markdown-docs/sql/create-type/index.md): `CREATE TYPE` defines a new data type. - [CREATE VIEW](https://materialize.com/docs/markdown-docs/sql/create-view/index.md): `CREATE VIEW` defines view, which provides an alias for the embedded `SELECT` statement. - [DEALLOCATE](https://materialize.com/docs/markdown-docs/sql/deallocate/index.md): `DEALLOCATE` clears a prepared statement. - [DECLARE](https://materialize.com/docs/markdown-docs/sql/declare/index.md): `DECLARE` creates a cursor. - [DELETE](https://materialize.com/docs/markdown-docs/sql/delete/index.md): `DELETE` removes values stored in tables. - [DISCARD](https://materialize.com/docs/markdown-docs/sql/discard/index.md): Discard resets state associated with the current session. - [DROP CLUSTER REPLICA](https://materialize.com/docs/markdown-docs/sql/drop-cluster-replica/index.md): `DROP CLUSTER REPLICA` removes an existing replica for the specified cluster. - [DROP CLUSTER](https://materialize.com/docs/markdown-docs/sql/drop-cluster/index.md): `DROP CLUSTER` removes an existing cluster from Materialize. - [DROP CONNECTION](https://materialize.com/docs/markdown-docs/sql/drop-connection/index.md): `DROP CONNECTION` removes a connection from Materialize. - [DROP DATABASE](https://materialize.com/docs/markdown-docs/sql/drop-database/index.md): `DROP DATABASE` removes a database from Materialize. - [DROP INDEX](https://materialize.com/docs/markdown-docs/sql/drop-index/index.md): DROP INDEX removes an index - [DROP MATERIALIZED VIEW](https://materialize.com/docs/markdown-docs/sql/drop-materialized-view/index.md): `DROP MATERIALIZED VIEW` removes a materialized view from Materialize. - [DROP NETWORK POLICY (Cloud)](https://materialize.com/docs/markdown-docs/sql/drop-network-policy/index.md): `DROP NETWORK POLICY` removes an existing network policy from Materialize. - [DROP OWNED](https://materialize.com/docs/markdown-docs/sql/drop-owned/index.md): `DROP OWNED` drops all the objects that are owned by one of the specified roles. - [DROP ROLE](https://materialize.com/docs/markdown-docs/sql/drop-role/index.md): `DROP ROLE` removes a role from Materialize. - [DROP SCHEMA](https://materialize.com/docs/markdown-docs/sql/drop-schema/index.md): `DROP SCHEMA` removes a schema from Materialize. - [DROP SECRET](https://materialize.com/docs/markdown-docs/sql/drop-secret/index.md): `DROP SECRET` removes a secret from Materialize's secret management system. - [DROP SINK](https://materialize.com/docs/markdown-docs/sql/drop-sink/index.md): `DROP SINK` removes a sink from Materialize. - [DROP SOURCE](https://materialize.com/docs/markdown-docs/sql/drop-source/index.md): `DROP SOURCE` removes a source from Materialize. - [DROP TABLE](https://materialize.com/docs/markdown-docs/sql/drop-table/index.md): `DROP TABLE` removes a table from Materialize. - [DROP TYPE](https://materialize.com/docs/markdown-docs/sql/drop-type/index.md): `DROP TYPE` removes a user-defined data type. - [DROP USER](https://materialize.com/docs/markdown-docs/sql/drop-user/index.md): `DROP USER` removes a role from Materialize. - [DROP VIEW](https://materialize.com/docs/markdown-docs/sql/drop-view/index.md): `DROP VIEW` removes a view from Materialize. - [EXECUTE UNIT TEST](https://materialize.com/docs/markdown-docs/sql/execute-unit-test/index.md): `EXECUTE UNIT TEST` defines a unit test for a view, run by mz-deploy against mocked input data. - [EXECUTE](https://materialize.com/docs/markdown-docs/sql/execute/index.md): `EXECUTE` - [EXPLAIN ANALYZE](https://materialize.com/docs/markdown-docs/sql/explain-analyze/index.md): Reference page for `EXPLAIN ANALYZE`. `EXPLAIN ANALYZE` is used to understand the performance of indexes and materialized views. - [EXPLAIN FILTER PUSHDOWN](https://materialize.com/docs/markdown-docs/sql/explain-filter-pushdown/index.md): `EXPLAIN FILTER PUSHDOWN` reports filter pushdown statistics for `SELECT` statements and materialized views. - [Explain plan operators](https://materialize.com/docs/markdown-docs/sql/explain-plan-operators/index.md) - [EXPLAIN PLAN](https://materialize.com/docs/markdown-docs/sql/explain-plan/index.md): Reference page for `EXPLAIN PLAN`. `EXPLAIN PLAN` is used to inspect the plans of `SELECT` statements, `SUBSCRIBE` statements, indexes, and materialized views. - [EXPLAIN SCHEMA](https://materialize.com/docs/markdown-docs/sql/explain-schema/index.md): `EXPLAIN KEY SCHEMA` or `EXPLAIN VALUE SCHEMA` is used to see the generated schemas for a `CREATE SINK` statement - [EXPLAIN TIMESTAMP](https://materialize.com/docs/markdown-docs/sql/explain-timestamp/index.md): `EXPLAIN TIMESTAMP` displays the timestamps used for a `SELECT` statement. - [FETCH](https://materialize.com/docs/markdown-docs/sql/fetch/index.md): `FETCH` retrieves rows from a cursor. - [SQL functions & operators](https://materialize.com/docs/markdown-docs/sql/functions/index.md): Learn more about the SQL functions and operators supported in Materialize - [array_agg function](https://materialize.com/docs/markdown-docs/sql/functions/array_agg/index.md): Aggregate values (including nulls) as an array. - [CAST and TRY_CAST](https://materialize.com/docs/markdown-docs/sql/functions/cast/index.md): Returns the value converted to the specified type - [COALESCE function](https://materialize.com/docs/markdown-docs/sql/functions/coalesce/index.md): Returns the first non-NULL element provided. - [csv_extract function](https://materialize.com/docs/markdown-docs/sql/functions/csv_extract/index.md): Returns separated values from a column containing a CSV file formatted as a string. - [date_bin function](https://materialize.com/docs/markdown-docs/sql/functions/date-bin/index.md): Bins a timestamp into a specified interval - [date_part function](https://materialize.com/docs/markdown-docs/sql/functions/date-part/index.md): Returns a specified time component from a time-based value - [date_trunc function](https://materialize.com/docs/markdown-docs/sql/functions/date-trunc/index.md): Truncates a timestamp at the specified time component - [datediff function](https://materialize.com/docs/markdown-docs/sql/functions/datediff/index.md): Returns the difference between two date, time or timestamp expressions based on the specified date or time part. - [encode and decode functions](https://materialize.com/docs/markdown-docs/sql/functions/encode/index.md): Converts binary data to and from textual representations - [EXTRACT function](https://materialize.com/docs/markdown-docs/sql/functions/extract/index.md): Returns a specified time component from a time-based value - [Aggregate function filters](https://materialize.com/docs/markdown-docs/sql/functions/filters/index.md): Use FILTER to specify which rows are sent to an aggregate function - [jsonb_agg function](https://materialize.com/docs/markdown-docs/sql/functions/jsonb_agg/index.md): Aggregates values (including nulls) as a jsonb array. - [jsonb_object_agg function](https://materialize.com/docs/markdown-docs/sql/functions/jsonb_object_agg/index.md): Aggregate keys and values (including nulls) into a jsonb object - [justify_days function](https://materialize.com/docs/markdown-docs/sql/functions/justify-days/index.md): Adjust interval so 30-day time periods are represented as months - [justify_hours function](https://materialize.com/docs/markdown-docs/sql/functions/justify-hours/index.md): Adjust interval so 24-hour time periods are represented as days - [justify_interval function](https://materialize.com/docs/markdown-docs/sql/functions/justify-interval/index.md): Adjust interval using justify_days and justify_hours, with additional sign adjustments - [LENGTH function](https://materialize.com/docs/markdown-docs/sql/functions/length/index.md): Returns the number of characters in a string. - [list_agg function](https://materialize.com/docs/markdown-docs/sql/functions/list_agg/index.md): Concatenates input values (including nulls) into a string. - [map_agg function](https://materialize.com/docs/markdown-docs/sql/functions/map_agg/index.md): Aggregate keys and values (excluding null keys) into a map - [normalize function](https://materialize.com/docs/markdown-docs/sql/functions/normalize/index.md): Returns a string normalized to the specified Unicode normalization form. - [now and mz_now functions](https://materialize.com/docs/markdown-docs/sql/functions/now_and_mz_now/index.md): Details the differences between the `now()` and `mz_now()` functions. - [Pushdown functions](https://materialize.com/docs/markdown-docs/sql/functions/pushdown/index.md): Functions for use with the filter pushdown feature - [string_agg function](https://materialize.com/docs/markdown-docs/sql/functions/string_agg/index.md): Concatenates the non-null input values into a string. Each value after the first is preceded by the corresponding delimiter (if it's not null). - [SUBSTRING function](https://materialize.com/docs/markdown-docs/sql/functions/substring/index.md): Returns substring at specified positions - [Table functions](https://materialize.com/docs/markdown-docs/sql/functions/table-functions/index.md): Functions that return multiple rows - [TIMEZONE and AT TIME ZONE functions](https://materialize.com/docs/markdown-docs/sql/functions/timezone-and-at-time-zone/index.md): Converts timestamp to a different time zone. - [to_char function](https://materialize.com/docs/markdown-docs/sql/functions/to_char/index.md): Converts a timestamp into a string using the specified format. - [GRANT PRIVILEGE](https://materialize.com/docs/markdown-docs/sql/grant-privilege/index.md): Grant privileges on a database object. - [GRANT ROLE](https://materialize.com/docs/markdown-docs/sql/grant-role/index.md): `GRANT` grants membership of one role to another role. - [Identifiers](https://materialize.com/docs/markdown-docs/sql/identifiers/index.md): SQL identifiers are names of columns and database objects such as sources and views. - [INSERT](https://materialize.com/docs/markdown-docs/sql/insert/index.md): `INSERT` inserts values into a table. - [Namespaces](https://materialize.com/docs/markdown-docs/sql/namespaces/index.md): SQL namespaces let you create a taxonomy of objects in Materialize. - [PREPARE](https://materialize.com/docs/markdown-docs/sql/prepare/index.md): `PREPARE` creates a prepared statement. - [REASSIGN OWNED](https://materialize.com/docs/markdown-docs/sql/reassign-owned/index.md): `REASSIGN OWNED` reassigns the owner of all the objects that are owned by one of the specified roles. - [RESET](https://materialize.com/docs/markdown-docs/sql/reset/index.md): Reset a configuration parameter to its default value. - [REVOKE PRIVILEGE](https://materialize.com/docs/markdown-docs/sql/revoke-privilege/index.md): `REVOKE` revokes privileges from a database object. - [REVOKE ROLE](https://materialize.com/docs/markdown-docs/sql/revoke-role/index.md): `REVOKE` revokes membership of one role from another role. - [ROLLBACK](https://materialize.com/docs/markdown-docs/sql/rollback/index.md) - [SELECT](https://materialize.com/docs/markdown-docs/sql/select/index.md): `SELECT` binds SQL queries to named views or materialized views, and allows to interactively query data maintained in Materialize . - [JOIN](https://materialize.com/docs/markdown-docs/sql/select/join/index.md): `JOIN` lets you combine two or more table expressions. - [Recursive CTEs](https://materialize.com/docs/markdown-docs/sql/select/recursive-ctes/index.md): Recursive CTEs are used to define recursive queries. - [SET](https://materialize.com/docs/markdown-docs/sql/set/index.md): Modify the value of a configuration parameter in the current session. - [SHOW CLUSTER REPLICAS](https://materialize.com/docs/markdown-docs/sql/show-cluster-replicas/index.md): `SHOW CLUSTER REPLICAS` lists the replicas for each cluster configured in Materialize. - [SHOW CLUSTERS](https://materialize.com/docs/markdown-docs/sql/show-clusters/index.md): `SHOW CLUSTERS` lists the clusters configured in Materialize. - [SHOW COLUMNS](https://materialize.com/docs/markdown-docs/sql/show-columns/index.md): `SHOW COLUMNS` lists the columns available for an object. - [SHOW CONNECTIONS](https://materialize.com/docs/markdown-docs/sql/show-connections/index.md): `SHOW CONNECTIONS` lists the connections configured in Materialize. - [SHOW CREATE CLUSTER](https://materialize.com/docs/markdown-docs/sql/show-create-cluster/index.md): `SHOW CREATE CLUSTER` returns the DDL statement used to create the cluster. - [SHOW CREATE CONNECTION](https://materialize.com/docs/markdown-docs/sql/show-create-connection/index.md): `SHOW CREATE CONNECTION` returns the statement used to create the connection. - [SHOW CREATE INDEX](https://materialize.com/docs/markdown-docs/sql/show-create-index/index.md): `SHOW CREATE INDEX` returns the statement used to create the index. - [SHOW CREATE MATERIALIZED VIEW](https://materialize.com/docs/markdown-docs/sql/show-create-materialized-view/index.md): `SHOW CREATE MATERIALIZED VIEW` returns the statement used to create the materialized view - [SHOW CREATE SINK](https://materialize.com/docs/markdown-docs/sql/show-create-sink/index.md): `SHOW CREATE SINK` returns the statement used to create the sink. - [SHOW CREATE SOURCE](https://materialize.com/docs/markdown-docs/sql/show-create-source/index.md): `SHOW CREATE SOURCE` returns the statement used to create the source. - [SHOW CREATE TABLE](https://materialize.com/docs/markdown-docs/sql/show-create-table/index.md): `SHOW CREATE TABLE` returns the SQL used to create the table. - [SHOW CREATE TYPE](https://materialize.com/docs/markdown-docs/sql/show-create-type/index.md): `SHOW CREATE TYPE` returns the DDL statement used to create the custom type. - [SHOW CREATE VIEW](https://materialize.com/docs/markdown-docs/sql/show-create-view/index.md): `SHOW CREATE VIEW` returns the `SELECT` statement used to create the view. - [SHOW DATABASES](https://materialize.com/docs/markdown-docs/sql/show-databases/index.md): `SHOW DATABASES` returns a list of all databases in Materialize. - [SHOW DEFAULT PRIVILEGES](https://materialize.com/docs/markdown-docs/sql/show-default-privileges/index.md): SHOW DEFAULT PRIVILEGES lists the default privileges granted on objects in Materialize. - [SHOW INDEXES](https://materialize.com/docs/markdown-docs/sql/show-indexes/index.md): SHOW INDEXES provides details about indexes built on a source, view, or materialized view - [SHOW MATERIALIZED VIEWS](https://materialize.com/docs/markdown-docs/sql/show-materialized-views/index.md): `SHOW MATERIALIZED VIEWS` returns a list of materialized views being maintained in Materialize. - [SHOW NETWORK POLICIES (Cloud)](https://materialize.com/docs/markdown-docs/sql/show-network-policies/index.md): `SHOW NETWORK POLICIES` returns a list of all network policies configured in Materialize. - [SHOW OBJECTS](https://materialize.com/docs/markdown-docs/sql/show-objects/index.md): `SHOW OBJECTS` returns a list of all objects in Materialize for a given schema. - [SHOW PRIVILEGES](https://materialize.com/docs/markdown-docs/sql/show-privileges/index.md): SHOW PRIVILEGES lists the privileges granted on all objects via role-based access control (RBAC). - [SHOW ROLE MEMBERSHIP](https://materialize.com/docs/markdown-docs/sql/show-role-membership/index.md): SHOW ROLE MEMBERSHIP lists the members of each role granted via role-based access control (RBAC). - [SHOW ROLES](https://materialize.com/docs/markdown-docs/sql/show-roles/index.md): `SHOW ROLES` lists the roles available in Materialize. - [SHOW SCHEMAS](https://materialize.com/docs/markdown-docs/sql/show-schemas/index.md): `SHOW SCHEMAS` returns a list of all schemas available in Materialize. - [SHOW SECRETS](https://materialize.com/docs/markdown-docs/sql/show-secrets/index.md): `SHOW SECRETS` lists the names of the secrets securely stored in Materialize's secret management system. - [SHOW SINKS](https://materialize.com/docs/markdown-docs/sql/show-sinks/index.md): `SHOW SINKS` returns a list of all sinks available in Materialize. - [SHOW SOURCES](https://materialize.com/docs/markdown-docs/sql/show-sources/index.md): `SHOW SOURCES` returns a list of all sources available in Materialize. - [SHOW SUBSOURCES](https://materialize.com/docs/markdown-docs/sql/show-subsources/index.md): `SHOW SUBSOURCES` returns the subsources in the current schema. - [SHOW TABLES](https://materialize.com/docs/markdown-docs/sql/show-tables/index.md): `SHOW TABLES` returns a list of all tables available in Materialize. - [SHOW TYPES](https://materialize.com/docs/markdown-docs/sql/show-types/index.md): `SHOW TYPES` returns a list of the data types in Materialize. - [SHOW VIEWS](https://materialize.com/docs/markdown-docs/sql/show-views/index.md): `SHOW VIEWS` returns a list of views in Materialize. - [SHOW](https://materialize.com/docs/markdown-docs/sql/show/index.md): Display the value of a configuration parameter. - [SUBSCRIBE](https://materialize.com/docs/markdown-docs/sql/subscribe/index.md): `SUBSCRIBE` streams updates from a source, table, view, or materialized view as they occur. - [System catalog](https://materialize.com/docs/markdown-docs/sql/system-catalog/index.md): The system catalog stores metadata about your Materialize instance. - [information_schema](https://materialize.com/docs/markdown-docs/sql/system-catalog/information_schema/index.md): information_schema is a system catalog that presents metadata in the format used by SQL standard. - [mz_catalog](https://materialize.com/docs/markdown-docs/sql/system-catalog/mz_catalog/index.md): mz_catalog is a system catalog that exposes metadata in Materialize's native format. - [mz_internal](https://materialize.com/docs/markdown-docs/sql/system-catalog/mz_internal/index.md): mz_internal is a system catalog schema which exposes internal metadata about Materialize. This schema is not part of Materialize's stable interface. - [mz_introspection](https://materialize.com/docs/markdown-docs/sql/system-catalog/mz_introspection/index.md): mz_introspection is a system catalog schema which contains replica introspection relations. This schema is not part of Materialize's stable interface. - [pg_catalog](https://materialize.com/docs/markdown-docs/sql/system-catalog/pg_catalog/index.md): pg_catalog is a system catalog that presents metadata in the format used by PostgreSQL. - [TABLE](https://materialize.com/docs/markdown-docs/sql/table/index.md): `TABLE` retrieves all rows from a single table. - [SQL data types](https://materialize.com/docs/markdown-docs/sql/types/index.md): Learn more about the SQL data types supported in Materialize - [Array types](https://materialize.com/docs/markdown-docs/sql/types/array/index.md): Express sequences of other types - [boolean type](https://materialize.com/docs/markdown-docs/sql/types/boolean/index.md): Expresses TRUE or FALSE - [bytea type](https://materialize.com/docs/markdown-docs/sql/types/bytea/index.md): Expresses a binary string - [date type](https://materialize.com/docs/markdown-docs/sql/types/date/index.md): Expresses a date without a specified time - [Floating-point types](https://materialize.com/docs/markdown-docs/sql/types/float/index.md): Express signed, inexact numbers - [Integer types](https://materialize.com/docs/markdown-docs/sql/types/integer/index.md): Express signed integers - [interval type](https://materialize.com/docs/markdown-docs/sql/types/interval/index.md): Expresses a duration of time - [jsonb type](https://materialize.com/docs/markdown-docs/sql/types/jsonb/index.md): Expresses a JSON object - [List types](https://materialize.com/docs/markdown-docs/sql/types/list/index.md): Lists are ordered sequences of homogenously typed elements - [map type](https://materialize.com/docs/markdown-docs/sql/types/map/index.md): Expresses a map - [mz_aclitem type](https://materialize.com/docs/markdown-docs/sql/types/mz_aclitem/index.md): Expresses a granted privilege on some object - [mz_timestamp type](https://materialize.com/docs/markdown-docs/sql/types/mz_timestamp/index.md): Expresses an internal timestamp - [numeric type](https://materialize.com/docs/markdown-docs/sql/types/numeric/index.md): Expresses an exact number with user-defined precision and scale - [oid type](https://materialize.com/docs/markdown-docs/sql/types/oid/index.md): Express a PostgreSQL-compatible object identifier - [record type](https://materialize.com/docs/markdown-docs/sql/types/record/index.md): A tuple with arbitrary contents - [text type](https://materialize.com/docs/markdown-docs/sql/types/text/index.md): Expresses a Unicode string - [time type](https://materialize.com/docs/markdown-docs/sql/types/time/index.md): Expresses a time without a specific date - [Timestamp types](https://materialize.com/docs/markdown-docs/sql/types/timestamp/index.md): Expresses a date and time - [Unsigned Integer types](https://materialize.com/docs/markdown-docs/sql/types/uint/index.md): Express unsigned integers - [uuid type](https://materialize.com/docs/markdown-docs/sql/types/uuid/index.md): Expresses a universally-unique identifier - [UPDATE](https://materialize.com/docs/markdown-docs/sql/update/index.md): `UPDATE` changes values stored in tables. - [VALIDATE CONNECTION](https://materialize.com/docs/markdown-docs/sql/validate-connection/index.md): `VALIDATE CONNECTION` validates the connection and authentication parameters provided in a `CREATE CONNECTION` statement against the target external system - [VALUES](https://materialize.com/docs/markdown-docs/sql/values/index.md): `VALUES` constructs a relation from value expressions.