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

AI Evolution Explained: GenAI vs LLMs vs AI Agents vs Agentic AI vs Intelligent AI

Artificial Intelligence (AI) is one of the most exciting technologies in our world today. But the terms that come with it like GenAI, LLMs, ...

MSDEVBUILD - English Channel

MSDEVBUILD - Tamil Channel

Popular Posts