import pymssql

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

cur.execute("DELETE FROM xxx_RAW_Device_Properties ")
cur.execute("DELETE FROM xxx_Virtual_Devices ")
cur.execute("DELETE FROM xxx_Device_Mappings ") 
cur.execute("DELETE FROM xxx_Plant_Device")

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

res = cur.fetchall()

for table_name in res:
    cur.execute("DROP TABLE [" + table_name[0] + "]")
    
   

conn.commit()
conn.close()