www.mimer.com/developer

Table Names

---

Any table name in a SELECT statement may be qualified by the name of the schema to which the table belongs in the form schema.table.

Unqualified table names are implicitly qualified by the ident name of the current user.

The table name must be written in the qualified form if the schema to which it belongs was not created by the current user, unless it is replaced by a synonym.

For example:

 SELECT  *
 FROM    HOTELADM.ROOMTYPES;

Result:

ROOMTYPE	DESCRIPTION
NSDBLB	NO SMOKING - DOUBLE WITH BATH
NSDBLS	NO SMOKING - DOUBLE WITH SHOWER
NSSGLB	NO SMOKING - SINGLE WITH BATH
NSSGLS	NO SMOKING - SINGLE WITH SHOWER
SDBLB	SMOKING - DOUBLE WITH BATH
SDBLS	SMOKING - DOUBLE WITH SHOWER
SSGLB	SMOKING - SINGLE WITH BATH
SSGLS	SMOKING - SINGLE WITH SHOWER

Upright Database Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 dbtechnology@upright.se