Reference database objects
To reference objects in other databases on the system, you must use three-level naming in the
format database_name.schema_name.object_name.
- database_name
- The name of the database where the object is defined.
- schema_name
- The schema in the database where the object is defined. In earlier Netezza Performance Server releases, Netezza Performance Server supported one schema per database, which matched the name of the database owner. Starting in Release 7.0.3, the system supports one schema by default, but it can be configured to support multiple schemas in a database. For more information, see Schema support.
- object_name
- The name of the table, view, synonym or other object.
A namespace is the structure underlying SQL schemas. The namespace contains all the objects within the schema plus all global objects (databases, users, groups, and system objects). By default, there is only one schema for each database, unless the system is configured to support multiple schemas per database.