Each row in the SYSSYNCSCRIPT system view identifies a stored procedure for scripted upload. This view is almost identical to the SYSSYNCSCRIPTS view, except that the values in this view are in their raw format.
The underlying system table for this view is ISYSSYNCSCRIPT.
| Column name | Data type | Description |
|---|---|---|
| pub_object_id | UNSIGNED BIGINT | The object ID of the publication to which the script belongs. |
| table_object_id | UNSIGNED BIGINT | The object ID of the table to which the script applies. |
| type | UNSIGNED INT | The type of upload procedure. |
| proc_object_id | UNSIGNED BIGINT | The object ID of the stored procedure to use for the publication. |
PRIMARY KEY (pub_object_id, table_object_id, type)
FOREIGN KEY (pub_object_id) references SYS.ISYSOBJECT (object_id)
FOREIGN KEY (table_object_id) references SYS.ISYSOBJECT (object_id)
FOREIGN KEY (proc_object_id) references SYS.ISYSOBJECT (object_id)