Create SQLite database under Windows

Description: After performing the Create SQLite database command under Windows, the database file will not be generated immediately and will not be generated until the table is created.

1. Place the Sqlite3.exe file in any location (as in D:\tools)
2. Under CMD, enter under D:\tools
3. At the CMD command prompt, enter Sqlite3 test.db (test.db is the database name) carriage return
Note: Now that the TEST.DB database has been created but it is still a temporary file, you need to enter the SQL command to create the table
4.create table Test (name text);
5. Then go to d:\tools under view generated a test.db file that's what we're creating the database
6. If you want to use this database the next time you still use sqlite3 test.db to access this database