GUI applicaiton to manage sql tables
To run the Database Table Creation Application, ensure you have Python and pip installed on your system.
-
Clone or download this repository to your local machine.
-
Navigate to the project directory in your terminal or command prompt.
-
Install the required dependencies using pip. Run the following command:
pip install tkinter sqlite3
This command will install
tkinter
andsqlite3
. -
Once the dependencies are installed, you can run the application by executing the main Python file. Run the following command:
python main.py
This command will start the Database Table Creation Application.
-
Upon running the application, you will be presented with a GUI interface.
-
Enter the table name and add columns by providing column names and selecting data types from the dropdown menu.
-
Click the "Add Column" button to add more columns if needed.
-
Once you have specified the table name and columns, click the "Create Table" button to create the table in the SQLite database.
-
The application will display the table structure, including the column names and data types.
-
You can close the application window when you are finished.
The Database Table Creation Application requires the following Python libraries:
tkinter
: Python's standard GUI toolkit.sqlite3
: SQLite3 library for interacting with SQLite databases.
These dependencies are commonly available in Python distributions.