Identifying tables or columns by their qualified object name

You can uniquely identify a table or column by adding other names that qualify it—the database name, owner’s name, and (for a column) the table or view name. Each qualifier is separated from the next one by a period. For example:

database.owner.table_name.column_name

database.owner.view_name.column_name

The naming conventions are:

[[database.]owner.]table_name

[[database.]owner.]view_name