A schema defines a local environment within which private database objects can be created. The ident creating the schema has the right to create objects in it and to drop objects from it.
PROGRAMident is created, a schema with the same name is automatically created by default, and the created ident becomes the creator of the schema. This happens unless
WITHOUT SCHEMAis specified in the
CREATE IDENTstatement. For idents who are not supposed to create database objects, it's good practice to specify
When a private database object is created, the name for it can be specified in a fully qualified form which identifies the schema in which it is to be created. The names of objects must be unique within the schema to which they belong, according to the rules for the particular object-type.
If an unqualified name is specified for a private database object, a schema name equivalent to the name of the current ident is assumed.
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40