Please use the form below to provide your feedback. Because your feedback is valuable to us, the information you submit in this form is recorded in our issue tracking system (JIRA), which is publicly available. You can track the status of your feedback using the ticket number displayed in the dialog once you submit the form.

Statements

  • reference
Statements are the commands that make up a SQL++ query. They can be categorized into three main groups: data definition language, data control language, and data manipulation language.

Data Definition Language

Data definition language (DDL) statements enable you to create and modify database objects, such as users, buckets, and indexes.

ALTER BUCKET
ALTER GROUP
ALTER INDEX
ALTER SEQUENCE
ALTER USER
ALTER VECTOR INDEX
BUILD INDEX
CREATE BUCKET
CREATE COLLECTION
CREATE FUNCTION
CREATE GROUP
CREATE INDEX
CREATE PRIMARY INDEX
CREATE SEQUENCE
CREATE SCOPE
CREATE USER
CREATE VECTOR INDEX
DROP BUCKET
DROP COLLECTION
DROP FUNCTION
DROP GROUP
DROP INDEX
DROP PRIMARY INDEX
DROP SEQUENCE
DROP SCOPE
DROP USER
DROP VECTOR INDEX

Data Control Language

Data control language (DCL) statements enable you to control which users or groups have access to data, and what they’re permitted to do with that data.

GRANT
REVOKE

Data Manipulation Language

Data manipulation language (DML) statements enable you to create, read, update, and delete data. Some DML statements may be further categorized as data query language, transaction control language, or utility statements.

DELETE
INSERT
MERGE
UPDATE
UPSERT

Data Query Language

Data query language (DQL) statements enable you to read and filter data and manipulate the results.

SELECT

Transaction Control Language

Transaction control language (TCL) statements enable you to work with Couchbase transactions.

BEGIN TRANSACTION
COMMIT TRANSACTION
ROLLBACK TRANSACTION
SAVEPOINT
SET TRANSACTION

Utility Statements

Utility statements do not manipulate data directly, but support other operations. For example, you can create and execute prepared statements, see query plans, get advice on query or index creation, and so on.

ADVISE
EXECUTE
EXECUTE FUNCTION
EXPLAIN
EXPLAIN FUNCTION
INFER
PREPARE
UPDATE STATISTICS
USING AI