added testcase to drop tables added during test runs
removed sqlite db, it is created/removed during testing
changed sql commands to uppercase and fixed delete all keyword