import pymssql

conn = pymssql.connect(server='db04.be4energy.com', user='be4visionadmin', password='cdg4s!fcv')
cur = conn.cursor()
cur.execute("use P1602507_2;")


cur.execute("DELETE FROM xxx_Plant_Device WHERE Date_and_Time>'2019-06-26 12:20:00'")

cur.execute("""SELECT name 
            FROM sys.tables 
            WHERE name LIKE 'Data_Table_%' """)

res = cur.fetchall()

for table_name in res:
    cur.execute("DELETE FROM [" + table_name[0] + "] WHERE Date_and_time>'2019-06-26 12:20:00' ")
    

conn.commit()
conn.close()