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:
Please Login to comment...