REMOVE_TSA_KEY_COLUMNS

Remove the IDC,BSK or BK defintion of a TSA object.

Parameter Name	Required	Parameter-Description
p_obj_schema	yes	TSA schema
p_obj_table	yes	TSA table
p_type	yes	type of key column (‘IDC’, ‘BSK’ or ‘BK’)
p_reset_flags	yes	reset flags that are changed with this execution (nullable, compare,…) - true/false (if not sure, use true and execute script for ‘IDC’, ‘BSK’ and ‘BK’ consecutively)

Example

EXECUTE SCRIPT api_reppsa.remove_tsa_key_columns
            ( 'XXX'    -- p_obj_schema
            , 'XXX'    -- p_obj_table
            , 'IDC'    -- p_type
            , false    -- p_reset_flags
            );