I want to delete all the SP accounts in my SD system. but all the accounts are related to the person record. i try to Update all, in the person view, but i cannot find the Account field. any suggestions??
Find someone who is. Messing around with the DB is dangerous and invalidate the support.
anyway persons are stored on itsm_persons and the column that holds the account oid is per_acc_oid.
However, just unrelating the persons with the accounts is not enough. If the account was used to create an item, you won't be able to delete the account. The same stands if the account was used to modify an item (or to be exact, if the account was used to modify an attribute that is audited in an item).