REMOVE_OBJECT

Remove all repository entries for a PSA object and all related physical objects.

Remove all repository entries for a PSA object and all dependent data like column definitions, relations to TSA objects, keys, BDATE and/or column expressions, join definitions, etc. If data exist in the PSA layer an error will be returned. In this case use the API EMPTY_PSA. With removing the object from the repository all database objects in PSA and PSB will be dropped as well.

Important

After removeing one or more objects with this API you must refresh metadata in REDADM and REPPSA:

execute script api_redadm.refresh;
execute script api_reppsa.refresh;

PSV objects are removed during automatic SCURTY refresh.

Parameter Name	Properties	Default Value	Parameter Description
p_psa_obj_schema	(PK)(NN)		Schema of the PSA object
p_psa_obj_table	(PK)(NN)		Name of the PSA object

Example

EXECUTE SCRIPT api_reppsa.remove_object
            ( 'XXX'    -- p_psa_obj_schema
            , 'XXX'    -- p_psa_obj_table
            );