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() 