Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Saturday, September 14, 2013

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