instance

(Cluster environments only) Returns the name for the SAP ASE with an ID that you provide, or the name of the SAP ASE from which it is issued if you do not provide a value for id.

Syntax

instance_name([id])

Parameters

id – is the ID of the SAP ASE with the name you are researching.

Examples

Example 1 – Returns the name of the instance with an ID of 12:
```
select instance_name(12)
```

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute instance_name.