Deleting Account Annotations
Use the aadelete.sql
file, installed in the sql
directory, to delete account annotations. It includes SQL queries that delete annotations for selected account names. To use the Clear Cell Detail feature to clear account annotations, see Clearing Cell Details.
To delete account annotations associated with account names:
- Stop the Web application server.
- Update the SQL queries section of the
aadelete.sql
file corresponding to your type of relational database by substituting the name of the account whose annotations to delete. - Run queries in the
aadelete.sql
file appropriate for your relational database.
Example: deleting account annotations for Account1
:
DELETE
FROM HSP_ACCOUNT_DESC
WHERE ACCOUNT_ID=(SELECT OBJECT_ID FROM HSP_OBJECT
WHERE OBJECT_NAME='ACCOUNT1')
INSERT INTO HSP_ACTION
(FROM_ID, TO_ID, ACTION_ID, OBJECT_TYPE, MESSAGE, ACTION_TIME, PRIMARY_KEY) VALUES (0,0,2,18,NULL,GETDATE(),NULL)