Re: [sqlite] testing for existence of an entity

this is likely a common and easy answer, so my for not being able to figure it out. How do I test for the existence of a table or a view so I can do something like... if exists then DROP else CREATE ()... what I do in such situations is SELECT 1 FROM

[sqlite] testing for existence of an entity

this is likely a common and easy answer, so my for not being able to figure it out. How do I test for the existence of a table or a view so I can do something like... if exists then DROP else CREATE ()... should I use CASE, or is there some other way?