Mimer SQL User's Manual TOC PREV NEXT INDEX

Mimer Developer Site

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
Mimer SQL User's Manual TOC PREV NEXT INDEX