Contents Index SYSSCHEDULE system table SYSSQLSERVERTYPE system table

ASA SQL Reference
  System Tables

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.


Contents Index SYSSCHEDULE system table SYSSQLSERVERTYPE system table