SurrealDB Docs Logo

Enter a search query

REMOVE statement

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

Statement syntax

SurrealQL Syntax
REMOVE [ NAMESPACE [ IF EXISTS ] @name | DATABASE [ IF EXISTS] @name | USER [ IF EXISTS ] @name ON [ ROOT | NAMESPACE | DATABASE ] | ACCESS [ IF EXISTS ] @name ON [ NAMESPACE | DATABASE ] | EVENT [ IF EXISTS ] @name ON [ TABLE ] @table | FIELD [ IF EXISTS ] @name ON [ TABLE ] @table | INDEX [ IF EXISTS ] @name ON [ TABLE ] @table | ANALYZER [ IF EXISTS ] @name | FUNCTION [ IF EXISTS ] fn::@name | PARAM [ IF EXISTS ] $@name | TABLE [ IF EXISTS ] @name ]

Example usage

Basic usage

The following queries show an example of how to remove resources

REMOVE NAMESPACE surrealdb; REMOVE DATABASE blog; REMOVE USER writer ON NAMESPACE; REMOVE USER writer ON DATABASE; REMOVE ACCESS token ON NAMESPACE; REMOVE ACCESS user ON DATABASE; REMOVE EVENT new_post ON TABLE article; -- Only works for Schemaful tables (i.e. tables with a schema) REMOVE FIELD tags ON TABLE article; REMOVE INDEX authors ON TABLE article; REMOVE ANALYZER example_ascii; REMOVE FUNCTION fn::update_author; REMOVE PARAM $author; REMOVE TABLE article;

Using if exists clause

Available since: v1.3.0

The following queries show an example of how to remove resources using the IF EXISTS clause, which will only remove the resource if it exists.

REMOVE NAMESPACE IF EXISTS surrealdb; REMOVE DATABASE IF EXISTS blog; REMOVE USER IF EXISTS writer ON NAMESPACE; REMOVE USER IF EXISTS writer ON DATABASE; REMOVE ACCESS IF EXISTS token ON NAMESPACE; REMOVE ACCESS IF EXISTS user ON DATABASE; REMOVE EVENT IF EXISTS new_post ON TABLE article; -- Only works for Schemaful tables (i.e. tables with a schema) REMOVE FIELD IF EXISTS tags ON TABLE article; REMOVE INDEX IF EXISTS authors ON TABLE article; REMOVE ANALYZER IF EXISTS example_ascii; REMOVE FUNCTION IF EXISTS fn::update_author; REMOVE PARAM IF EXISTS $author; REMOVE TABLE IF EXISTS article;

On this page

© SurrealDB GitHub Discord Community Cloud Features Releases Install