How to Delete/Cleanup ATG Profiles from Database?

As an ATG developer or a support person, you may need to remove an ATG profile completely from the system. It is just not removing reference from dps_user table, but removing a complete history of the user profile. Here is the table names and SQL query for removing.

Word of Caution: Please note that this is applicable only when you have extended the profile repository and custom tables are not listed and you have to remove the data from them as well.

SQL: delete from < db table name > where < column name > = ”;

List of tables

dps_user_prevpwd
dps_user_org
dps_user_address
dps_user_roles
dps_user_org_anc
dps_user_mailing
dps_user_scenario
dps_scenario_value
dps_user_slot
dps_usr_markers
dss_user_bpmarkers
dcs_usr_actvpromo
dcs_usr_usedpromo
dcs_user
dcs_user_wishlist
dcs_user_giftlist
dcs_user_otherlist
dcs_user_catalog
dps_usr_creditcard
dps_other_addr
dps_mailing
dps_mail_trackdata
dps_user_mailing
dps_email_address
dps_user

Leave a Reply

Your email address will not be published. Required fields are marked *

CAPTCHA Image
Play CAPTCHA Audio
Reload Image