[sqlite] Is it possible that dropping a big table takes very long

[Simon Slavin]

On 16 Apr 2016, at 2:32pm, Cecil Westerhof <cldwesterhof at gmail.com> wrote:

> ?I work with Java. With:
>    SELECT SQLITE_VERSION()
> I get:
>    3.8.11?

Thanks.

> ?How can I get the journal mode in Jav??
> With DB Browser I get Delete.
> But when I in sqlite3 give:
>    PRAGMA schema.journal_mode;
> I get:
>    Error: unknown database schema

That is not well explained.  Try just

PRAGMA journal_mode;

Simon.