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 Information Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 info@mimer.se