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:

  1. Stop the Web application server.

  2. 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.

  3. 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)