running none SQL commands in SQLite?

Answered

I am evaluating DataGrip right now to use with SQLite.  There are times the program needs to run raw non SQL commands, such as PRAGMA <...> or maybe .schema [tablename], I would like to see the output the database will provide, is there a way to execute these commands in DataGrid?

3 comments

@Scarleton

You just need to execute your queries in Console:

0

So what I am doing is entering the command in this window and then I click on the green arrow.  Then it gives me the error "Nothing to run", what am I doing wrong?

0

IDE supports PRAGMA commands, but do not support sqlite3 (dot-commands).

As a workaround you can use sqlite3 CLI in Terminal:

0

Please sign in to leave a comment.