|
Each row in the SYSSERVER system view describes a remote server. The underlying system table for this view is ISYSSERVER.
NotePrevious 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 | Column constraint |
|---|---|---|
| srvid | UNSIGNED INT | NOT NULL |
| srvname | VARCHAR(128) | NOT NULL |
| srvclass | LONG VARCHAR | NOT NULL |
| srvinfo | LONG VARCHAR | |
| srvreadonly | CHAR(1) | NOT NULL |
srvid An identifier for the remote server.
srvname The name of the remote server.
srvclass The server class, as specified in the CREATE SERVER statement.
srvinfo Server information.
srvreadonly Y if the server is read only, and N otherwise.
PRIMARY KEY (srvid)