CREATE SCHEMA

Home

4D v20 R7

CREATE SCHEMA



	Command CREATE SCHEMACREATE SCHEMA sql_name

Beschreibung

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.

Example

Creation of a schema named "Accounting_Rights":

CREATE SCHEMA Accounting_Rights

Siehe auch

ALTER SCHEMA