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 can also be created automatically and the created ident becomes the creator of the schema. This happens by default unless
WITHOUT SCHEMAis specified in the
When a private database object is created, its name 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