Drops a database (schema) and deletes the directory associated with the database from the file system. An exception is thrown if the schema 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.
database_name: The name of an existing database (schema) in the system. If the name does not exist, an exception is thrown.
If specified, will restrict dropping a non-empty database and is enabled by default.
If specified, will drop all the associated tables and functions.