Function documentationGET_OBJECTNAME(x,o) Locate this document in the navigation structure

 

The string function GET_OBJECTNAME(x,o) returns the name of the database object.

Identifier of the object: x

The argument x is a string literal in the format [<schema_name>.]<identifier> or a character parameter of this type. Schema schema_name or identifier identifier can be special identifiers.

Object type: o

You can use one of the following key words:

GET_OBJECTNAME(x,o)

x, o

Result of the Function GET_OBJECTNAME(x,o)

x identifies an object that is not of object type o

NULL Value

Object x does not exist

NULL Value

Object x exists, however the current user does not have any privileges for this object

NULL Value

Object x exists for the schema specified under schema_name and the current user has a privilege for this object

identifier

Object x exists, and the current user has a privilege for this object

First object name found in the search hierarchy

For some object types, there is no search hierarchy. In this case, the function only searches for the object in the schema of the current database user.

More Information

GET_SCHEMA(x,o)