In SQLite, the sqlite3 command is used to create a new database.
Your database name should be unique within the RDBMS.
How to create database:
First open command prompt and set the path. After that you can check that sqlite directory by using "dir" command.
Let's create a database name "JTP.db":
The database is created now. You can check the created database by using the ".databases" command.
You can see the created database in also in the root folder.
The SQLite .quit command is used to be come out of the sqlite prompt:
The .dump dot command is used to export complete database in a text file by using SQlite command at command prompt.
sqlite3 JTP.db .dump > JTP.sql
Now, the complete database is exported in a text file. You can see it in the root folder.