Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Reference » Views » System views


SYSSERVER system view

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


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 Data 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