if i deleted data from list.and then remove from recyclebin it should deleted from share point database. but it is not deleted from DB.instead of delete data, it add a flag in colum. but it will consume unneccessary db space. how we can delete all deleted data from DB.

hi Stanfford, Thanks for reply. But i think it should need to delete from Alluserdata List also. because all data information are store in this table.

Yes, you are right. please pay attendtion to this note in the link: Disclaimer: This code is a way to remove items that have been deleted from SharePoint but not deleted from the underlying database. It is a non-conventional method that would probably not be recommended by Microsoft and could violate support agreements. Only the person running this code is responsible for the results. It is always recommended that any data is backed-up before deletion.