DROP DATABASE (SQL Analytics)
Drops a database and deletes the directory associated with the database from the file system. An exception is thrown if the database does not exist in the system.
Parameters
DATABASE | SCHEMA
DATABASE
andSCHEMA
mean the same thing, either of them can be used.IF EXISTS
If specified, no exception is thrown when the database does not exist.
RESTRICT
If specified, will restrict dropping a non-empty database and is enabled by default.
CASCADE
If specified, will drop all the associated tables and functions.