SYSSERVER system view

Each row in the SYSSERVER system view describes a remote server. The underlying system table for this view is ISYSSERVER.

Note

Previous versions of the catalog contained a SYSSERVERS system table. That table has been renamed to be ISYSSERVER (without an 'S'), and is the underlying table for this view.

Column name Column type Description
srvid UNSIGNED INT An identifier for the remote server.
srvname VARCHAR(128) The name of the remote server.
srvclass LONG VARCHAR The server class, as specified in the CREATE SERVER statement.
srvinfo LONG VARCHAR Server information.
srvreadonly CHAR(1) Whether the server is read only.
Constraints on underlying system table

PRIMARY KEY (srvid)