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

Remove Column from Clinical Data Model Table

Use this API to delete a column from a table.

Name

DME_PUB_DF_DATA_MODEL.RemoveColumnsInDataModelTab

Signature

procedure RemoveColumnsInDataModelTab(
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 column to be removed. This is a parameter of type CDR_NAMING_LIST_COLL.

Parent topic: Create and Modify Clinical Data Models