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 | 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. |
PRIMARY KEY (srvid)
| Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |