Python MySQL Drop Table

You can delete an existing table by using the "DROP TABLE" statement:

Delete the table "customers":

host="localhost", user=" yourusername ", password=" yourpassword ", database="mydatabase" ) mycursor = mydb.cursor() sql = "DROP TABLE customers" mycursor.execute(sql)

If the table you want to delete is already deleted, or for any other reason does not exist, you can use the IF EXISTS keyword to avoid getting an error.

Delete the table "customers" if it exists:

host="localhost", user=" yourusername ", password=" yourpassword ", database="mydatabase" ) mycursor = mydb.cursor() sql = "DROP TABLE IF EXISTS customers" mycursor.execute(sql)