If you are unwilling to do a "DROP VIEW IF EXISTS" and "DROP TABLE IF EXISTS", then settle for one succeeding, you can query the sqlite_master table. If the view or table exists under a suspected name, it will show up there, along with it form as 'table' or 'view' in the "type" column.