The Drop Table query affects the structure of the table rather than the data. It is used to remove an existing table. When you are unsure whether a table to be dropped exists or not, use the DROP TABLE IF EXISTS command.

Syntax:

Following is the syntax of the DROP TABLE query in MySQL −

DROP TABLE table_name;

Example: Program to demonstrate drop if exists. 

import mysql.connector

# Connecting to the Database
mydb = mysql.connector.connect(
host ='localhost',
database ='College',
user ='root',
)
cs = mydb.cursor()
  
# drop clause
statement = "Drop Table if exists Employee"
  
# Uncommenting statement ="DROP TABLE employee"
# Will raise an error as the table employee
# does not exists
  
cs.execute(statement)
      
# Disconnecting from the database
mydb.close()

The IF EXISTS keyword is used to prevent errors from occurring when attempting to drop a table that does not exist.

When we use the IF EXISTS clause, we are telling the SQL engine that if the given table name exists, drop it; otherwise, do nothing.

If the code executes without an error, then it means the employee table is deleted if it existed.

Note: also read about Delete Query – MySQL

Follow Me

Please follow me to read my latest post on programming and technology if you like my post.

https://www.instagram.com/coderz.py/

https://www.facebook.com/coderz.py

Rabecca Fatima

Staying up to the mark is what defines me. Hi all! I’m Rabecca Fatima a keen learner, great enthusiast, ready to take new challenges as stepping stones towards flying colors.