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.

SQLite Create database 1

Example:

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

snippet
sqlite3 JTP.db
SQLite Create database 2

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

snippet
.databases
SQLite Create database 3

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

SQLite Create database 4

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
SQLite Create database 5

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

SQLite Create database 6
Related Tutorial
Follow Us
https://www.facebook.com/Rookie-Nerd-638990322793530 https://twitter.com/RookieNerdTutor https://plus.google.com/b/117136517396468545840 #
Contents