Overview of database object references

You can reference schema objects in the context of an SQL statement in OceanBase Database.

OceanBase Database supports the following types of references in the current version:

• References to schema objects

• References to partitioned tables and indexes

• References to object type attributes and methods

The general syntax for referencing is as follows:

[ schema. ] object [ .part ]

where:

• object specifies the name of the object.

• schema specifies the schema that contains the object. This qualifier allows users to reference objects in other schemas after being granted the appropriate privileges. If omitted, it defaults to the user's own schema.

  schema applies only to schema objects such as tables, views, indexes, partitions, sequences, synonyms, triggers, and PL objects (such as PL subprograms, packages, and triggers). It cannot be used for non-schema objects such as users, roles, and directories. Public synonyms can optionally use PUBLIC with quotes.

• part specifies a part of the object. This identifier allows you to reference parts of a schema object, such as columns or partitions of a table. However, it is not applicable to all types of objects.