Referring to schema objects and parts
- Last Updated: May 12, 2026
- 1 minute read
- OpenAccess SDK
- Version 9.0
- Documentation
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.