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

Improving C# Performance by Using AsSpan and Avoiding Substring

During development and everyday use, Substring is often the go-to choice for string manipulation. However, there are cases where Substring c...

MSDEVBUILD - English Channel

MSDEVBUILD - Tamil Channel

Popular Posts