You are here: System database > sysinstances
   |
   |
|
sysinstances
|
|
|
|
There is one row per server instance in the cluster in the sysinstances table.
Table Columns
|
Name |
Type |
Description |
|
id |
INTEGER |
Id of the instance, unique within the cluster machine |
|
endpoint |
VARCHAR |
Connection endpoint. This is the connection string for the network protocol. This will be '<ip-number>:<port-number>' for a TCP/IP connection, or <server-name>/<pipe-name>/scimore for a named pipe. |
|
network |
INTEGER |
Network protocol identifier. 1: TCP/IP |
|
server |
VARCHAR |
server name - redundant/deprecated |
|
current |
SMALLINT |
This will be 1 for the one instance that the query is run through. Other instances in the cluster will be 0. |
Related