|
|
|
|
|
|
|
|
|
|
version 11.3
DROP SCHEMA sql_name
Description
The DROP SCHEMA command can be used to delete the schema designated by sql_name.
It is possible to delete any schema except for the default schema (DEFAULT_SCHEMA). When you delete a schema, all the tables that were assigned to it are transferred to the default schema. The transferred tables inherit the access rights of the default schema.
If you attempt to remove a schema that does not exist or that has already been deleted, an error is generated.
Only the database Designer and Administrator can delete schemas.
Example
You want to delete the MyFirstSchema schema (to which Table1 and Table2 are assigned):
DROP SCHEMA MyFirstSchema
After this operation, the two tables, Table1 and Table2, are reassigned to the default schema.
See Also
ALTER SCHEMA, CREATE SCHEMA, REVOKE.
|
|
|
|
|
|
|
|
|
|