VOOZH about

URL: https://www.geeksforgeeks.org/python/python-sqlite-drop-table/

⇱ Python SQLite - DROP Table - GeeksforGeeks


  • Courses
  • Tutorials
  • Interview Prep

Python SQLite - DROP Table

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.

Output:

👁 Image

Now, Insert 5 records into the customer_address table.

Output:

👁 Image

After insertion let's see how to execute the drop table command.

Output:

👁 Image
Comment
Article Tags:
Article Tags: