4D Doc Center : DROP SCHEMA

4D v13.4

DROP SCHEMA



	Command DROP SCHEMDROP 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) 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.

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.