delete all files which contains word sql_Table1

[DeaD_EyE]

Use pathlib:

from pathlib import Path


def remove_files(root, pattern):
    for element in Path(root).rglob(pattern):
        if element.is_file():
            element.unlink()


if __name__ == "__main__":
    tbl = "*sql_Table1*"
    # using the wildcard for rglob()
    folderpath = "E:\\test\reports"
    remove_files(folderpath, tbl)