skip to main content
Basic elements of SQL : Referring to schema objects and parts
 

Referring to schema objects and parts

The general syntax for referring to a schema object is:
qualifier.owner.table_name
qualifier.owner.table_name.column_name
Note: The term catalog is synonymous with qualifier and the term schema is synonymous with owner.
You can include spaces around the periods separating the components of the reference to the object, but it is conventional to omit them. Qualifying the object names with qualifier and owner is optional.