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.