Chapter 15 System Tables
1035
SYSSERVERS system table
Column name Column type
Column
constraint
Table
Constraints
srvid INTEGER NOT NULL Primary key
srvname VARCHAR(128) NOT NULL
srvclass LONG
VARCHAR
NOT NULL
srvinfo LONG
VARCHAR
srvreadonly CHAR(1) NOT NULL
Each row describes a remote server.
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.