Display Metadata Differences between Tables
Use this API to display the differences found when comparing metadata in two tables.
Name
DME_PUB_DF_DATA_MODEL.get_tab_metadata_diff
Signature
FUNCTION GET_TAB_METADATA_DIFF (piCompID IN CDR_NAMINGS.COMPANY_ID%TYPE ,piSrcTabObjID IN CDR_NAMINGS.OBJ_ID%TYPE ,piSrcTabObjVer IN CDR_NAMING_VERSIONS.OBJ_VER%TYPE ,piTgtTabObjID IN CDR_NAMINGS.OBJ_ID%TYPE ,piTgtTabObjVer IN CDR_NAMING_VERSIONS.OBJ_VER%TYPE ) RETURN dme_char_coll;
Parameters
This API has standard parameters (see Standard Parameters) and the following parameters:
- COMPANY_ID (Mandatory): To get your company ID, use CDR_PUB_DEF_FACTORY_UTILS.GetCompanyId.
- TABLE1_OBJID (Mandatory): The object ID of the first table being compared.
- TABLE1_OBJVER (Mandatory): The object version of the first table being compared.
- TABLE2_OBJID (Mandatory): The object ID of the second table being compared.
- TABLE2_OBJVER (Mandatory): The object version of the second table being compared.
Parent topic: Create and Modify Clinical Data Models