Each row of the SYSPROXYTAB system view describes the remote parameters of one proxy table. The underlying system table for this view is ISYSPROXYTAB.
| Column name | Data type | Description |
|---|---|---|
| table_object_id | UNSIGNED BIGINT | The object ID of the proxy table. |
| existing_obj | CHAR(1) | Indicates whether the proxy table previously existed on the remote server . |
| srvid | UNSIGNED INT | The unique ID for the remote server associated with the proxy table. |
| remote_location | LONG VARCHAR | The location of the proxy table on the remote server. |
PRIMARY KEY (table_object_id)
FOREIGN KEY (table_object_id) references ISYSOBJECT (object_id) MATCH UNIQUE FULL
FOREIGN KEY (srvid) references SYS.ISYSSERVER (srvid)