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