ml_model_check_version_schema system procedure

Use this procedure to check the status of each schema object required by deployed synchronization models. This stored procedure returns information for the specified script version.

Syntax

ml_model_check_version_schema ( 
'script_version' 
)

Parameters

Syntax	Description
script_version	VARCHAR(128). The name of the script version associated with the synchronization model you want to check.

Remarks

This procedure returns a result set containing the status of each schema object required by the specified script version.

No results are returned for script versions installed outside of Sybase Central or for synchronization models deployed prior to version 16.

The result set contains the following columns:

schema_owner Identifies the schema owner.
table_name Identifies the table name.
schema_type Identifies the schema type. It can be one of the following types:
- TABLE
- INDEX
- COLUMN
- TRIGGER
- PROCEDURE
object_name Identifies the object name.
locked If this column is set to 1 then the schema is never modified or dropped by the plug-in. Schema used by synchronization models that pre-existed before a deployment is marked as locked.
status Status can be one of the following:
- INSTALLED The schema is installed correctly.
- MISSING The schema is not installed.
- MISMATCH The installed schema is different from what is required.
- UNVERIFIED The schema exists, but there is not enough information to determine that it is defined correctly.
- UNUSED No synchronization model is using this schema object.
overwrite_action Can be one of the following:
- REPLACE If the model is redeployed, the existing schema is dropped and recreated
- CREATE If the model is redeployed, the schema is created.
- SKIP Either the schema is already correctly installed, or there is conflicting schema that is blocking proper installation.
preserve_action Reserved for future use.

ml_model_check_version_schema system procedure

Syntax

Parameters

Remarks

See also