Deleting Table
DROP is used to delete the entire database or a table. It deleted both records in the table along with the table structure.
Syntax:
DROP TABLE TABLE_NAME;
Example: Drop SQLite3 table using Python
Total tables in the gfg.db before dropping
Now let’s drop the Student table and then again check the total table in our database.
Python3
# Import moduleimport sqlite3# Connecting to sqliteconn = sqlite3.connect('gfg.db')# Creating a cursor object using# the cursor() methodcursor = conn.cursor()# Updatingcursor.execute('''DROP TABLE Student;''')# Commit your changes in the databaseconn.commit()# Closing the connectionconn.close() |
Output:
Note: To learn more about SQLit3 with Python refer to our Python SQLite3 Tutorial.
SQL using Python
In this article, integrating SQLite3 with Python is discussed. Here we will discuss all the CRUD operations on the SQLite3 database using Python. CRUD contains four major operations –
Note: This needs a basic understanding of SQL.
Here, we are going to connect SQLite with Python. Python has a native library for SQLite3 called sqlite3. Let us explain how it works.