Skip to content
Related Articles

Related Articles

Python SQLite – DROP Table

Improve Article
Save Article
  • Last Updated : 27 Apr, 2021
Improve Article
Save Article

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

Output:


My Personal Notes arrow_drop_up
Related Articles

Start Your Coding Journey Now!