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.

DROP SCOPE

  • Capella Operational
  • reference
    +
    The DROP SCOPE statement enables you to delete a scope.

    Syntax

    drop-scope ::= 'DROP' 'SCOPE' ( namespace ':' )? bucket '.' scope ( 'IF' 'EXISTS' )?
    Syntax diagram: refer to source code listing
    namespace

    (Optional) An identifier that refers to the namespace of the bucket which contains the scope you want to delete. Currently, only the default namespace is available. If the namespace name is omitted, the default namespace in the current session is used.
    bucket

    (Required) An identifier that refers to the bucket which contains the scope you want to delete.
    scope

    (Required) An identifier that refers to the name of the scope that you want to delete.
    If there is a hyphen (-) inside the bucket name or the scope name, you must wrap that part of the path in backticks (` `). For example, default:`travel-sample` indicates the travel-sample keyspace in the default namespace.

    IF EXISTS Clause

    The optional IF EXISTS clause enables the statement to complete successfully when the specified scope doesn’t exist. If the scope does not exist within the specified bucket, then:

    • If this clause is not present, an error is generated.

    • If this clause is present, the statement does nothing and completes without error.

    Usage

    When you delete a scope, any collections within that scope are deleted also.

    Example

    This statement deletes a scope called events in the travel-sample bucket.

    DROP SCOPE `travel-sample`.events