Creating Tables in SQLite
Similar to other databases, we use same syntax in SQLite. The command used to create a table is,
sqlite> create table table_name( column_name datatype(size) constraint);
After creating a table we can access it or retrieve it by using the below command,
sqlite> .tables
Example for creation of table named geek1 with geek_id of integer as primary key.
As we have seen above how to create databases in SQLite and creation of tables in SQLite databases, now we will look how to connect a SQLite database file using other method, i.e., using ATTACH statement.
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