SQLite Create Database

In SQLite, the sqlite3 command is used to create a new database.

Syntax:

snippet

sqlite3 DatabaseName.db

Your database name should be unique within the RDBMS.

Note

Note: The sqlite3 command: The sqlite3 command is used to create database. But, if the database does not exist then a new database file with the given name will be created automatically.

How to create database:

First open command prompt and set the path. After that you can check that sqlite directory by using "dir" command.

Example:

Let's create a database name "JTP.db":

snippet

sqlite3 JTP.db

The database is created now. You can check the created database by using the ".databases" command.

snippet

.databases

You can see the created database in also in the root folder.

The .quit Command

The SQLite .quit command is used to be come out of the sqlite prompt:

.quit

The .dump Command

The .dump dot command is used to export complete database in a text file by using SQlite command at command prompt.

For example:

snippet

sqlite3 JTP.db .dump > JTP.sql

Now, the complete database is exported in a text file. You can see it in the root folder.