DEL_TABLE Procedure

If the provided table exists within the user's schema's table based User Interface Defaults, the UI Defaults for it is deleted. This includes the deletion of any groups defined for the table and all the columns associated with the table.

Syntax

APEX_UI_DEFAULT_UPDATE.DEL_TABLE (
    p_table_name            IN VARCHAR2);

Parameters

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

DEL_TABLE Parameters

Parameter	Description
`p_table_name`	Table name

Example

The following example removes the UI Defaults for the EMP table that are associated with the current schema.

begin
    apex_ui_default_update.del_table (
       p_table_name => 'EMP' );
end;
/