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 usually is created and the created ident becomes the creator of the schema. This happens by default unless
WITHOUT SCHEMAis specified in the
CREATE IDENTstatement. A user without a schema is not allowed to create any database objects at all.
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 connected ident is assumed.
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40