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

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;
/