Each row in the SYSSYNCSCRIPT system view identifies a stored procedure for MobiLink scripted upload. This view is almost identical to the SYSSYNCSCRIPTS view, except that the values in this view are in their raw format. To see them in their human-readable format, see SYSSYNCSCRIPTS consolidated view.
Refer to the SYSPUBLICATION system view for information about which publications use scripted upload, and refer to the SYSPROCEDURE system view for the stored procedure definitions.
The underlying system table for this view is ISYSSYNCSCRIPT.
|Column name||Column type||Column constraint|
|pub_object_id||UNSIGNED BIGINT||NOT NULL|
|table_object_id||UNSIGNED BIGINT||NOT NULL|
|type||UNSIGNED INT||NOT NULL|
|proc_object_id||UNSIGNED BIGINT||NOT NULL|
pub_object_id The object ID of the publication to which the script belongs.
table_object_id The object ID of the table to which the script applies.
type The type of upload procedure.
proc_object_id 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)