So this time you got messed up with the Amibroker database? and want to delete the data not the symbols? Then here is a simple hack for you to remove the complete data from your messed about database.
Steps to Follow
2)Now to File Menu->Database Settings and select Disable option in the local data storage
3)Now Close and reopen amibroker. You will find that all your data got dropped and only your symbol remains
4)Now if you are having realtime data subscription then do a simple scan for all symbols which will backfill all the symbols. (Make sure you have the enough symbol limit rights to backfill).
5)Now once again to goto File Menu->Database Settings and select Enable option in the local data storage and this will ensure that all your data got stored. Probably now your database is error free.
Note : This works only with licensed amibroker version. If you are using amibroker trial version then you might not have the rights to store the database for offline use.