Applies to: Databricks SQL Databricks Runtime 9.1 and above
Drops a schema and deletes the directory associated with the schema from the file system. An exception is thrown if the schema does not exist in the system. To drop a schema you must be its owner.
While usage of
DATABASE is interchangeable,
SCHEMA is preferred.
If specified, no exception is thrown when the schema does not exist.
The name of an existing schemas in the system. If the name does not exist, an exception is thrown.
If specified, restricts dropping a non-empty schema and is enabled by default.
If specified, drops all the associated tables and functions recursively. In Unity Catalog, dropping a schema using
CASCADEsoft-deletes tables: managed table files will be cleaned up after 30 days, but external files are not deleted. Warning! If the schema is managed by the workspace-level Hive metastore, dropping a schema using
CASCADErecursively deletes all files in the specified location, regardless of the table type (managed or external).