Skip to main content
Skip table of contents

DROP DATABASE/SCHEMA

Removes a database/schema from the system. The physical operations involve removing the metadata for the database from the warehouse.


Syntax

syntax

BASH
DROP (DATABASE|SCHEMA) [IF EXISTS] database_name [CASCADE];

<database_name>

The complete name of the database/schema you want to delete


CASCADE

When you do not use the CASCADE clause, drop all the objects inside the database manually before dropping the database itself.

The CASCADE clause to make drop all tables and other objects in the database before dropping the database itself.


Output

This SQL command does not return anything.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.