How to run arbitrary SQLite query from Visual Studio?

Question

I cannot believe this is the first time this has happened. I have a script that looks like this:

drop table if exists Recipients

drop table if exists Messages

create table Recipients (
    Id INTEGER not null,
   Name TEXT,
   Email TEXT,
   primary key (Id)
)

create table Messages (
    Id INTEGER not null,
   Subject TEXT,
   Contents TEXT,
   SentOn DATETIME,
   primary key (Id)
)

and I just want to start it using an SQLite connection in my server explorer, but the only way I can find SQL execution is against silly query builders.

I do not need anything visually. I just need a panel on which I can click "Run" and it will run the script.

Answer 1

sqlite3 filename.db < input.sql

Answer 2

SQLite, SQL Express node " " " ". !, .

, , . , , "" , "SQL".

Answer 3

http://sqliteadmin.orbmu2k.de/