Installation of SQLite Database
After installation of the SQLite database engine, create a folder in your desired directory. Now using the command prompt navigate to the directory where you have created the folder and use the below command to create a SQLite database file.
sqlite> sqlite3 database_name.db;
After the creation of the database, we can access it using the below command.
sqlite> .databases
Example for creation and access of database file named ‘geeks.db’
How to list the Tables in a SQLite Database File ?
SQLite is a database engine which is written in C programming language. SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world.
The source code for SQLite is in the public domain. SQLite engine is not a standalone process like other databases, you can link it statically or dynamically as per your requirement with your application. SQLite accesses its storage files directly. In this article, we’ll learn how to list all the tables in a SQLite database file that was opened with an ATTACH statement. Before moving into the topic some prerequisites required are
Contact Us