[sqlite] Re: efficient way to figure out if a table is empty

[Igor Tandetnik]

Xavier Noria <[EMAIL PROTECTED]> wrote:

Not that is critical for my application, but just for curiosity which
is the recommended idiom to figure out whether a table has any

register?

select exists (select * from tablename);

Igor Tandetnik

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------