Open In App
Related Articles

Python SQLite – DROP Table

Improve
Improve
Improve
Like Article
Like
Save Article
Save
Report issue
Report

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:



Last Updated : 27 Apr, 2021
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads