sqlite3.exe 


C:\MDAD>sqlite3 www.db
SQLite version 3.7.6.3
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .databases
seq  name             file
---  ---------------  ----------------------------------------------------------
0    main             C:\MDAD\www.db
sqlite> select * from TelDirList;
Error: no such table: TelDirList
sqlite> create table if not exists TelDirList (recId integer PRIMARY KEY autoincrement, Name text, Tel text);
sqlite> select * from TelDirList;
sqlite> insert into TelDirList (Name ,Tel) values( 'abc',123);
sqlite> insert into TelDirList (Name ,Tel) values( 'abc',1223);
sqlite> select * from TelDirList;
1|abc|123
2|abc|1223
sqlite> .exit

C:\MDAD>sqlite3 www.db
SQLite version 3.7.6.3
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> select * from TelDirList;
1|abc|123
2|abc|1223
sqlite>


Browse Android Studio Emulator SQLite Database


(Tested but does not work for AndroidStudio db files but work for other db files)

Use of SqliteBrowser to view sqlite file created by sqlite3


Reference:
Sqlite Database Tutorial
at