ALTER CONNECTION

Modify the properties of a connection.

ALTER DEFAULT PRIVILEGES

Set privileges for objects created in the future.

ALTER DATABASE

Modify the properties of a database.

ALTER FUNCTION

Modify the properties of a function.

ALTER INDEX

Modify the properties of an index.

ALTER MATERIALIZED VIEW

Modify the properties of a materialized view.

ALTER SCHEMA

Modify the properties of a schema.

ALTER SINK

Modify the properties of a sink.

ALTER SOURCE

Modify the properties of a source.

ALTER SUBSCRIPTION

Modify the properties of a subscription.

ALTER SWAP

Modify the names between two database objects.

ALTER SYSTEM

Modify a server configuration parameter.

ALTER TABLE

Modify the properties of a table.

ALTER USER

Modify the properties of a user.

ALTER VIEW

Modify the properties of a view.

AS CHANGELOG

Convert stream into an append-only changelog.

BEGIN

Start a transaction.

CANCEL JOBS

Cancel specific streaming jobs.

COMMENT ON

Add comments on tables or columns.

COMMIT

Commit the current transaction.

CREATE AGGREGATE

Create a user-defined aggregate function.

CREATE CONNECTION

Create a connection between VPCs.

CREATE DATABASE

Create a new database.

CREATE FUNCTION

Create a user-defined function.

CREATE INDEX

Create an index on a column of a table or a materialized view to speed up data retrieval.

CREATE MATERIALIZED VIEW

Create a materialized view.

CREATE SCHEMA

Create a new schema.

CREATE SECRET

Create a secret to store credentials.

CREATE SINK INTO

Create a sink into RisingWave’s table.

CREATE SINK

Create a sink.

CREATE SOURCE

Supported data sources and how to connect RisingWave to the sources.

CREATE TABLE

Create a table.

CREATE USER

Create a new user account.

CREATE VIEW

Create a non-materialized view.

DELETE

Remove rows from a table.

DESCRIBE

Get information about the columns in a table, source, sink, view, or materialized view.

DISCARD

Discard session state.

DROP AGGREGATE

Drop a user-defined aggregate function.

DROP CONNECTION

Remove a connection.

DROP DATABASE

Remove a database.

DROP FUNCTION

Drop a user-defined function.

DROP INDEX

Remove an index.

DROP MATERIALIZED VIEW

Remove a materialized view.

DROP SCHEMA

Remove a schema.

DROP SECRET

Drop a secret.

DROP SINK

Remove a sink.

DROP SOURCE

Remove a source.

DROP TABLE

Remove a table.

DROP USER

Remove a user.

DROP VIEW

Drop a view.

EXPLAIN

Show the execution plan of a statement.

EXPLAIN ANALYZE

Analyze the actual runtime performance of a streaming job.

FLUSH

Commit pending data changes and persist updated data to storage.

GRANT

Grant a user privileges.

INSERT

Insert new rows of data into a table.

RECOVER

Trigger recovery manually.

REVOKE

Revoke privileges from a user.

SELECT

Retrieve data from a table or a materialized view.

SET BACKGROUND_DDL

Run Data Definition Language (DDL) operations in the background.

SET RW_IMPLICIT_FLUSH

Enable or disable implicit flushes after batch operations.

SET TIME ZONE

Set time zone.

SET

Change a run-time parameter.

SHOW CLUSTER

Show the details of your RisingWave cluster.

SHOW COLUMNS

Show columns in a table, source, sink, view or materialized view.

SHOW CONNECTIONS

Show existing connections.

SHOW CREATE INDEX

Show the query used to create the specified index.

SHOW CREATE MATERIALIZED VIEW

Show the query used to create the specified materialized view.

SHOW CREATE SINK

Show the query used to create the specified sink.

SHOW CREATE SOURCE

Show the query used to create the specified source.

SHOW CREATE TABLE

Show the query used to create the specified table.

SHOW CREATE VIEW

Show the query used to create the specified view.

SHOW CURSORS

Show all cursors in the current session.

SHOW DATABASES

Show existing databases.

SHOW FUNCTIONS

Show all user-defined functions.

SHOW INDEXES

Show existing indexes from a particular table.

SHOW INTERNAL TABLES

Show internal tables to learn about the existing internal states.

SHOW JOBS

Show all streaming jobs.

SHOW MATERIALIZED VIEWS

Show existing materialized views.

SHOW PARAMETERS

Show the details of the system parameters.

SHOW PROCESSLIST

Display system current workload.

SHOW SCHEMAS

Show existing schemas.

SHOW SINKS

Shows all sinks.

SHOW SOURCES

Show existing sources.

SHOW SUBSCRIPTION CURSORS

Show all subscription cursors in the current session.

SHOW TABLES

Show existing tables.

SHOW VIEWS

Show existing views.

START TRANSACTION

Start a transaction.

UPDATE

Modify existing rows in a table.