# dropSchema

suspend fun dropSchema(vararg schemas: Schema, cascade: Boolean = false, inBatch: Boolean = false)

Drops schemas

Note that when you are using Mysql or MariaDB, this will fail if you try to drop a schema that contains a table that is referenced by a table in another schema.

#### Parameters

schemas

the names of the schema

cascade

flag to drop schema and all of its objects and all objects that depend on those objects. Note This option is not supported by MySQL, MariaDB, or SQL Server, so all objects in the schema will be dropped regardless of the flag's value.

inBatch

flag to perform schema creation in a single batch

#### Samples

org.jetbrains.exposed.v1.r2dbc.sql.tests.shared.SchemaTests.testDropSchemaWithCascade