Hi Lendy,
HOWTO60731 (http://www.symantec.com/docs/HOWTO60731) have the steps to delete the target from the item table. Is recommended to always have a SQL database backup before manual changes in the database.
In this HOWTO there are four steps and sql querys:
Step 1 is to find the targed GUID. Replace ANYPC by the target name.
Use Symantec_CMDB
select * from Item where name like 'ANYPC '
Step 2 is to check if it have any relation.
Use Symantec_CMBD
select * from ItemReference where ChildItemGuid like '2hgh-GUID FROM THE FIRST QUERY-5bbi32'
Step 3 use it only when you will get any results from Step 2 we need to break any relation that exist.
Use Symantec_CMDB
delete from ItemReference where ParentGuid like ‘PARENTGUID FROM STEP 3’ and ChildGuid like 'GUID FROM Step1'
Step 4 is to delete it from item table
USE Symantec_cmdb
delete from Item where name like 'ANYPC '
Regards,