Create SQLite Table
Overview
In this tutorial, we will learn how to create an SQLite table. DB Browser for SQLite database tool lets you create tables.
Create SQLite Table
To create a table, we need to know the schema of the table. For example, the number of columns, data type of each column, default values, table constraints, Primary key, Foreign key, etc.
The two main ways to create the SQLite table are as follows:
- Use the SQL CREATE table query on the command line.
- Use the DB Browser GUI Tool.
This section will use the DB Browser tool to create the table. Follow the below steps to create a table.
Launch DB Browser tool.
To create a table, open the database where you want to create it.
To create a table, click on the Create Table tab. This will open the table definition window to enter the details of the table that you wish to create.
Click the Add button to add the columns to the table definition.
Click on OK after you are done with the table specifications.
Once you have added the columns, click the OK button, and the table should appear under the database you created.
—
Python Tutorials
Python Tutorial on this website can be found at:
https://www.testingdocs.com/python-tutorials/
More information on Python is available at the official website: