[sqlite] testing for existence of an entity

[Puneet Kishor]

this is likely a common and easy answer, so my <blushes> 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 <table|view> exists
then DROP <table|view>
else CREATE <table|view> ()...
should I use CASE, or is there some other way?

And while we are at it... how do I loop over a bunch of results and do 
something with them?

I guess, in other words, or perhaps an additional question, what is the 
(PL|T)/SQL parallel for SQLite, if any?

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]