How to drop a sqlite table in python according to a variable name passed through a function [duplicate]

Question

def refreshDatabase(table):
    
    c.execute("DROP TABLE ?", (table,))
        
    conn.commit()

    createNewTable(table)

Hey, how can I drop the Table that is declared as a parameter when calling the function? It doesn't seem to work with this syntax. thanks in advance!

Answer 1

Take a look here

You can't substitute table name at SQL side, so change it from Python (which is not safe of course)

def refreshDatabase(table):
    c.execute(f"DROP TABLE {table}")
    conn.commit()
    createNewTable(table)