Table-Reference

Syntax

[[database.]schema.]table[ [AS] alias]

Parameters

[database.]schema

Specifies a schema, by default public. If schema is any schema other than public, you must supply the schema name. For example:

myschema.thisDbObject

If you specify a database, it must be the current database.

table A table in the logical schema.
[AS] alias

A temporary name used for references to table.