C# code to execute sql data definition language statements

Question

 Hello friends...

I m assigned a task to develop an application for creating, altering and dropping databases, tables, stored procedures, functions and creating database backup and so on. at runtime. for I googled for it but failed to get information about it. I m using C# 4.0 to develop the application. Please help me.

Answer 1

Hi Monika,


Pragma automatic_index command is by deafult true in Sqlite.

so when you  used Pragma automatic_index=true, its mean indexing will be continue


to stop default indexing use 

sqlite> Pragma automatic_index=false.