SQL statements: Right to erasure

Individuals have the right to ask your organization to delete any personal information about them that your organization holds. The following table lists personal data that is stored in WebSphere Commerce and shows how to delete the data by using an SQL query.


Type of personal data	SQL query and database table
Address	`DELETE FROM ADDRESS WHERE MEMBER_ID=?;`
Birth date	`DELETE FROM USERDEMO WHERE USERS_ID = ?;`
Browsing Behavior	`DELETE FROM DMUSERBHVR WHERE DMUSERBHVR.PERSONALIZATIONID IN (?PERSONALIZATIONID?)`
Challenge answer	`DELETE FROM USERREG WHERE USERS_ID = ?;`
Currency	`DELETE FROM USERS WHERE USERS_ID = ?;`
Demographics	`DELETE FROM USERDEMO WHERE USERS_ID = ?;`
Email Address or IBMid	`DELETE FROM ADDRESS WHERE MEMBER_ID=?;`
Gender	`DELETE FROM USERDEMO WHERE USERS_ID = ?;`
Income	`DELETE FROM USERDEMO WHERE USERS_ID = ?;`
Language	`DELETE FROM USERS WHERE USERS_ID = ?;`
Logon ID	`DELETE FROM USERREG WHERE USERS_ID = ?;`
Name	`DELETE FROM ADDRESS WHERE MEMBER_ID=?;`
Order History	`DELETE FROM ORDERS WHERE MEMBER_ID =?;`
Password (for shoppers and CSRs)	`DELETE FROM USERREG WHERE USERS_ID = ?;`
Phone Number	`DELETE FROM ADDRESS WHERE MEMBER_ID=?;`
Referral URL	`DELETE FROM DMUSERBHVR WHERE DMUSERBHVR.PERSONALIZATIONID IN (?PERSONALIZATIONID?)`
Search History	`DELETE FROM DMUSERBHVR WHERE DMUSERBHVR.PERSONALIZATIONID IN (?PERSONALIZATIONID?)`