1. API Guide
  2. Oracle Health Sciences Data Management Workbench APIs
  3. Clinical Data Models
  4. Create and Modify Clinical Data Models
  5. Remove Constraint from a Clinical Data Model Table

Remove Constraint from a Clinical Data Model Table

Use this API to remove a constraint from a table.

Name

DME_PUB_DF_DATA_MODEL.RemoveConsInDataModelTab

Signature

procedure RemoveConsInDataModelTab(
p_api_version 	IN NUMBER
p_init_msg_list 	IN VARCHAR2 default CDR_PUB_DEF_CONSTANTS.G_FALSE
p_commit 		IN VARCHAR2 default CDR_PUB_DEF_CONSTANTS.G_FALSE
p_validation_level	IN NUMBER default CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL
x_return_status 	OUT NOCOPY VARCHAR2
x_msg_count 	OUT NOCOPY NUMBER
x_msg_data 		OUT NOCOPY VARCHAR2
pi_naming_coll	IN  cdr_naming_list_coll);

Parameters

This API has standard parameters (see Standard Parameters) and the following parameters:

PI_NAMING_COLL (Mandatory): Identify the constraint to be removed. This is a parameter of type CDR_NAMING_LIST_COLL that contains list of CDR naming version attributes.

Parent topic: Create and Modify Clinical Data Models