|
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 | Column type | Column constraint |
|---|---|---|
| table_object_id | UNSIGNED BIGINT | NOT NULL |
| existing_obj | CHAR(1) | |
| srvid | UNSIGNED INT | |
| remote_location | LONG VARCHAR |
table_object_id The object ID of the proxy table.
existing_obj Indicates whether the proxy table previously existed on the remote server (Y/N).
srvid The unique ID for the remote server associated with the proxy table.
remote_location 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)