SYSSYNCSCRIPT system view

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.

For information about which publications use scripted upload, see SYSPUBLICATION system view.

For information about stored procedure definitions, see SYSPROCEDURE system view.

The underlying system table for this view is ISYSSYNCSCRIPT.

Column name Column 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.
Constraints on underlying system table

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)

See also