SQLite :: How to create Database?

SQLite

How to create Database?

How to Get All Database Name?

SQLite>.Database
Above query retrieve all database name with location
“ Main “ is default database name .

How to Create New Database Name?
Database name same as “Main “but location of database storage we can store different name
Like “Testdb.db

Step 1:

Go to Run

Step 2:

Type CMD

Step 3:

Sync location. Where exe located
My Exe located in C:\Sqlite.exe

Step 4:

C:\>sqlite3.exe Sample.db
Example Screen below

.db file store location ? Is it store C:\Sample.db?
No
C:\Users\<YourName>\AppData\Local\VirtualStore\sample.db

How to modify above location?

Step 1:

Go to My computer

Step 2:

Right Click èProperty

Step 3:

Advanced System Settings

Step 4:

Environment variables

Step 5:


Note:

Whenever open New Sqlite window execute below query
C:\>sqlite3.exe Sample.db












0 Comments

Featured Post

Understanding about Azure Region, Geographies, Availability Zones and Region Pairs

Introduction Microsoft Azure services are available in 53 regions around the world, with plans announced for 7 additional regions and 140+ a...

Subscribe to the FREE Weekly Newsletter to receive all the latest Microsoft Azure, AI, Xamarin

Popular Posts