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