DEL_COLUMN Procedure

If the provided table and column exists within the user's schema's table based User Interface Defaults, the UI Defaults for it are deleted.

Syntax

APEX_UI_DEFAULT_UPDATE.DEL_COLUMN (
    p_table_name            IN VARCHAR2,
    p_column_name           IN VARCHAR2);

Parameters

Table: DEL_COLUMN Parameters describes the parameters available in the DEL_COLUMN procedure.

DEL_COLUMN Parameters

Parameter	Description
`p_table_name`	Name of table whose column's UI Defaults are to be deleted.
`p_column_name`	Name of columns whose UI Defaults are to be deleted.

Example

The following example deletes the column CREATED_BY from the EMP table definition within the UI Defaults Table Dictionary within the current schema.

BEGIN
    apex_ui_default_update.del_ad_column (
       p_table_name  => 'EMP',
       p_column_name => 'CREATED_BY' );
END;