Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


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 its qualified form if the name of the schema to which the table belongs differs from the name of the current user.

For example:
 SELECT *
    FROM mimer_store.formats;
Returns:

FORMAT_ID
 FORMAT
CATEGORY_ID
DISPLAY_ORDER
1
 Audio CD
1
20
2
 Cassette
1
30
3
 DVD Audio
1
10
4
 Vinyl
1
40
5
 Audio Cassette
2
40
6
 Audio CD
2
30
7
 Hardcover
2
10
8
 Paperback
2
20
9
 DVD Video
3
10
10
 Video
3
20


Mimer
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
info@mimer.se
Mimer SQL Documentation TOC PREV NEXT INDEX