Python SQLite - DROP Table

Last Updated : 27 Apr, 2021

In this article, we will discuss the DROP command in SQLite using Python. But first, let's get a brief about the drop command.

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;

For dropping table, we will first create a database and a table in it. Let's create a table in the database.

Python3

# importing sqlite module
import sqlite3

# create connection to the database 
# geeks_database
connection = sqlite3.connect('geeks_database.db')

# create table named address of customers with
# 4 columns id,name age and address
connection.execute('''CREATE TABLE customer_address
         (ID INT PRIMARY KEY     NOT NULL,
         NAME           TEXT    NOT NULL,
         AGE            INT     NOT NULL,
         ADDRESS        CHAR(50)); ''')

# close the connection
connection.close()

Output:

Now, Insert 5 records into the customer_address table.

Python3

# importing sqlite module
import sqlite3

# create connection to the database 
# geeks_database
connection = sqlite3.connect('geeks_database.db')

# insert records into table
connection.execute(
    "INSERT INTO customer_address VALUES (1, 'nikhil teja', 22, 'hyderabad' )")

connection.execute(
    "INSERT INTO customer_address VALUES (2, 'karthik', 25, 'khammam')")

connection.execute(
    "INSERT INTO customer_address VALUES (3, 'sravan', 22, 'ponnur' )")

connection.execute(
    "INSERT INTO customer_address VALUES (4, 'deepika', 25, 'chebrolu' )")

connection.execute(
    "INSERT INTO customer_address VALUES (5, 'jyothika', 22, 'noida')")

# close the connection
connection.close()

Output:

After insertion let's see how to execute the drop table command.

Python3

# importing sqlite module
import sqlite3

# create connection to the 
# database geek
connection = sqlite3.connect('geeks_database.db')

# drop table
connection.execute("DROP TABLE customers_address")

print("data dropped successfully")

# close the connection
connection.close()