Python SQLite – DROP Table Read Courses Practice 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 Python SQLite - Update Data Next Python SQLite - Update Specific Column Share your thoughts in the comments Add Your Comment Please Login to comment...
