Python SQLite – DROP Table
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 moduleimport sqlite3 # create connection to the database # geeks_databaseconnection = sqlite3.connect('geeks_database.db') # create table named address of customers with# 4 columns id,name age and addressconnection.execute('''CREATE TABLE customer_address (ID INT PRIMARY KEY NOT NULL, NAME TEXT NOT NULL, AGE INT NOT NULL, ADDRESS CHAR(50)); ''') # close the connectionconnection.close() |
Output:
Now, Insert 5 records into the customer_address table.
Python3
# importing sqlite moduleimport sqlite3 # create connection to the database # geeks_databaseconnection = sqlite3.connect('geeks_database.db') # insert records into tableconnection.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 connectionconnection.close() |
Output:
After insertion let’s see how to execute the drop table command.
Python3
# importing sqlite moduleimport sqlite3 # create connection to the # database geekconnection = sqlite3.connect('geeks_database.db') # drop tableconnection.execute("DROP TABLE customers_address") print("data dropped successfully") # close the connectionconnection.close() |
Output:
Attention geek! Strengthen your foundations with the Python Programming Foundation Course and learn the basics.
To begin with, your interview preparations Enhance your Data Structures concepts with the Python DS Course. And to begin with your Machine Learning Journey, join the Machine Learning – Basic Level Course
