Document Center

All Products

Document Center

ApsaraDB for ClickHouse:SQL statements

Last Updated:Jun 17, 2026

ApsaraDB for ClickHouse supports the following SQL statements.

SQL statement	References
SELECT	SELECT
INSERT INTO	INSERT INTO
CREATE	CREATE
ALTER	ALTER
DELETE	DELETE
SYSTEM	SYSTEM
SHOW	SHOW
GRANT	GRANT
EXPLAIN	EXPLAIN
REVOKE	REVOKE
ATTACH	ATTACH
CHECK TABLE	CHECK TABLE
DESCRIBE TABLE	DESCRIBE TABLE
DETACH	DETACH
DROP	DROP
EXISTS	EXISTS
KILL	KILL
OPTIMIZE	OPTIMIZE
RENAME	RENAME
EXCHANGE	EXCHANGE
SET	SET
SET ROLE	SET ROLE
TRUNCATE	TRUNCATE
USE	USE
WATCH	WATCH
MOVE	MOVE
UNDROP TABLE	UNDROP TABLE