This is the legacy 4D documentation web site. Documentations are progressively being moved to developer.4d.com
SQL Commands
DROP SCHEMA
|
|
||
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) and the schema containing the system tables ("SYSTEM_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.
You want to delete the MyFirstSchema schema (to which Table1 and Table2 are assigned):
DROP SCHEMA MyFirstSchemaAfter this operation, the two tables, Table1 and Table2, are reassigned to the default schema.
Product: 4D
Theme: SQL Commands
4D SQL Reference ( 4D v20 R8)
