SHOW REFERENCES¶

Lists the references defined for an application in the manifest file and the references the consumer has associated to the application.

Syntax¶

SHOW REFERENCES IN APPLICATION <name>

Copy

This command displays the following information about the references defined for the application:

Column	Description
name	The name of the reference.
label	The label of the reference as specified in the manifest file.
description	A description of the reference and what it does.
privileges	The privileges that the reference requires. Refer to Object types and privileges that a reference can contain for the list of privileges that a reference can required for an object.
object_type	The type of object associated with the reference. Refer to Object types and privileges that a reference can contain for a list of the supported objects for a reference.
multi-valued	Indicates if the reference requires more than one type of object.
object_name	The name of the object specified by the reference after the consumer associates the object with the application.
schema_name	The name of the schema of the object associated with this reference or NULL if no object has been associated or if the associated object is an account object.
database_name	The name of database of the object associated with this reference or NULL if one of the following is true: No object is specified in the reference definition. The object is not a database or database object.
alias	A name that uniquely identifies a reference to an object, including the object name, scope and privileges