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()
Output:
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4