RisingWave home page
Current (v2.4)
Search...
⌘K
Ask AI
Blog
Sign up free
Sign up free
Search...
Navigation
Commands
SQL commands
Guides
Apache Iceberg™
SQL/UDFs
Python SDK
Client Libraries
RisingWave Console
Changelog
Join Slack community
GitHub
SQL reference
Overview
Commands
Overview
ALTER CONNECTION
ALTER DEFAULT PRIVILEGES
ALTER DATABASE
ALTER FUNCTION
ALTER INDEX
ALTER MATERIALIZED VIEW
ALTER SCHEMA
ALTER SECRET
ALTER SINK
ALTER SOURCE
ALTER SUBSCRIPTION
ALTER SWAP
ALTER SYSTEM
ALTER TABLE
ALTER USER
ALTER VIEW
AS CHANGELOG
BEGIN
CANCEL JOBS
COMMENT ON
COMMIT
CREATE AGGREGATE
CREATE CONNECTION
CREATE DATABASE
CREATE FUNCTION
CREATE INDEX
CREATE MATERIALIZED VIEW
CREATE SCHEMA
CREATE SECRET
CREATE SINK INTO
CREATE SINK
CREATE SOURCE
CREATE TABLE
CREATE USER
CREATE VIEW
DELETE
DESCRIBE
DISCARD
DROP AGGREGATE
DROP CONNECTION
DROP DATABASE
DROP FUNCTION
DROP INDEX
DROP MATERIALIZED VIEW
DROP SCHEMA
DROP SECRET
DROP SINK
DROP SOURCE
DROP TABLE
DROP USER
DROP VIEW
EXPLAIN
EXPLAIN ANALYZE
FLUSH
GRANT
INSERT
RECOVER
REVOKE
SELECT
SET BACKGROUND_DDL
SET RW_IMPLICIT_FLUSH
SET TIME ZONE
SET
SHOW CLUSTER
SHOW COLUMNS
SHOW CONNECTIONS
SHOW CREATE INDEX
SHOW CREATE MATERIALIZED VIEW
SHOW CREATE SINK
SHOW CREATE SOURCE
SHOW CREATE TABLE
SHOW CREATE VIEW
SHOW CURSORS
SHOW DATABASES
SHOW FUNCTIONS
SHOW INDEXES
SHOW INTERNAL TABLES
SHOW JOBS
SHOW MATERIALIZED VIEWS
SHOW PARAMETERS
SHOW PROCESSLIST
SHOW SCHEMAS
SHOW SINKS
SHOW SOURCES
SHOW SUBSCRIPTION CURSORS
SHOW TABLES
SHOW VIEWS
START TRANSACTION
UPDATE
Query syntax
Data types
Functions and operators
Identifiers
System catalogs
Psql commands
User-defined functions
Overview
External UDFs
Embedded UDFs
SQL UDFs
Commands
SQL commands
Overview of the SQL commands supported by RisingWave.
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.
Was this page helpful?
Yes
No
Suggest edits
Raise issue
Overview
ALTER CONNECTION
Assistant
Responses are generated using AI and may contain mistakes.