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.
DATABASE | SCHEMA
SCHEMAmean the same thing, either of them can be used.
If specified, no exception is thrown when the database does not exist.
If specified, will restrict dropping a non-empty database and is enabled by default.
If specified, will drop all the associated tables and functions.