REMOVE

REMOVE statement

The REMOVE statement is used to remove resources such as databases, tables, indexes, events and more. Similar to a SQL DROP statement.

Statement syntax

SurrealQL Syntax

REMOVE [
    NAMESPACE @name
    | DATABASE @name
    | USER @name ON [ ROOT | NAMESPACE | DATABASE ]
    | LOGIN @name ON [ NAMESPACE | DATABASE ]
    | TOKEN @name ON [ NAMESPACE | DATABASE ]
    | SCOPE @name
    | TABLE @name
    | EVENT @name ON [ TABLE ] @table
    | FUNCTION fn::@name
    | FIELD @name ON [ TABLE ] @table
    | INDEX @name ON [ TABLE ] @table
    | PARAM $@name
]

Example usage

Basic usage

The following queries show an example of how to remove resources

REMOVE NAMESPACE surrealdb;

REMOVE DATABASE blog;

REMOVE LOGIN writer ON NAMESPACE;

REMOVE USER writer ON NAMESPACE;

REMOVE TOKEN writer_token ON NAMESPACE;

REMOVE SCOPE documentation;

REMOVE TABLE article;

REMOVE EVENT new_post ON TABLE article;

REMOVE FUNCTION fn::update_author;

-- Only works for Schemaful tables (i.e. tables with a schema)
REMOVE FIELD tags ON TABLE article;

REMOVE INDEX authors ON TABLE article;

REMOVE PARAM $author;