in Python/length_of_stay_utils.py [0:0]
def drop_view(view_name, connection_string):
pyodbc_cnxn = pyodbc.connect(connection_string)
pyodbc_cursor = pyodbc_cnxn.cursor()
pyodbc_cursor.execute("IF OBJECT_ID ('{}', 'V') IS NOT NULL DROP VIEW {} ;".format(view_name, view_name))
pyodbc_cursor.close()
pyodbc_cnxn.commit()
pyodbc_cnxn.close()