Creating a database table

In this recipe, we will be learning to create a database table. The user will be prompted to specify the database name, followed by the table name that is to be created. The recipe enables you to enter column names and their data types. Upon clicking the push button, the table with the defined columns will be created in the specified database.

How to do it…

Here are the steps to create a GUI that enables the user to enter all the information for the database table to be created. Using this GUI, the user can specify the database name, column names, and choose column types too:

1. Let's create an application based on the Dialog without Buttons template.
2. Add five QLabel, three QLineEdit, one QComboBox, and two QPushButton widgets to the form by dragging and dropping five Label, three Line Edit, one Combo Box, and two Push Button widgets on the form.
3. Set the text property of the first four Label widgets to Enter database name, Enter table name, Column Name, and Data Type.
4. Delete...