Menu
Do you know any way to create sql script from existing database in SQLite 3?
487
In SQLite, sqlite3 command is used to create a new SQLite database. You do not need to have any special privilege to create a database.
Open a command prompt (cmd.exe) and 'cd' to the folder location of the SQL_SAFI. sqlite database file. run the command 'sqlite3' This should open the SQLite shell and present a screen similar to that below.
ALTER: It is used to modify an existing database object like a table.
I need to create tables and insert script.
You can use the sqlite3 command line tool and use .dump to output the SQL that creates the database schema and inserts the data there.
98
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
