You can also see the respective SQL to create the table. If you look closely at the above figure, you will see that it contains the exact details that you wanted to be incorporated in the table consumers. To create a table, click on the Create Table tab and you will be prompted to enter the details of the table that you wish to create. Note: If you are familiar with database schema designing, you might recollect that the field consumer_id is the primary key of the table (that is why it is underlined).
An empty database of the name that you entered will be created instantaneously, and you will be prompted to create a table under that database. Give a name of your choice and then proceed. To do this, you can click on the New Database tab -Īfter clicking on the New Database tab, you will be prompted to enter a name for the database.
Once you are ready with the DB Browser tool, you can create a new SQLite database to proceed.
SQLITE BROWSER DOWNLOAD WINDOWS 7 WINDOWS 7
On a Windows 7 platform, the interface for DB Browser for SQLite looks like this. To start, you will first download this tool from here with respect to your OS platform. For this tutorial, you will be using DB Browser for SQLite. You can use SQLite from the command line tools, but there is a GUI-based utility which lets you use SQLite through a decent graphical interface. Installing and setting up SQLite takes a matter of a few minutes. Once you feel comfortable working with SQL and Python, you can come back and resume from where you left off.
SQLITE BROWSER DOWNLOAD WINDOWS 7 FULL
For example, it does not support joins like RIGHT OUTER JOIN and FULL OUTER JOIN. However, there are some limitations of SQLite as well.