This is the legacy 4D documentation web site. Documentations are progressively being moved to developer.4d.com
SQL Commands
CREATE SCHEMA
|
|
||
The CREATE SCHEMA command is used to create a new SQL schema named sql_name in the database. You can use any sql_name except for "DEFAULT_SCHEMA" and "SYSTEM_SCHEMA".
Note: For more information about schemas, please refer to the Principles for integrating 4D and the 4D SQL engine section.
When you create a new schema, by default the following access rights are associated with it:
- Read-only (Data): <Everybody>
- Read/Write (Data): <Everybody>
- Full (Data & Structure): <Nobody>
Each schema can be attributed external access rights using the GRANT command.
Only the Designer and Administrator of the database can create, modify or delete schemas.
Warning: The SQL schema implementation requires that access management system of 4D is activated (in other words, a password has been assigned to the Designer). Otherwise, all users can create and modify schemas with no restriction.
When a database is created or converted with 4D v11 SQL (starting with release 3), a default schema is created in order to group together all the tables of the database. This schema is named "DEFAULT_SCHEMA". It cannot be deleted or renamed.
Creation of a schema named "Accounting_Rights":
CREATE SCHEMA Accounting_Rights
Product: 4D
Theme: SQL Commands
4D SQL Reference ( 4D v20 R7)
