HYTOS

                    sql = "delete from [Views] where Drawings_UID='{}'".format(drawing.UID)

                    # multi table delete not support in mssql

                    ''' 

                    sql = f"delete LINE_DATA_LIST, TitleBlockValues, LineNoAttributes, Attributes, Associations, Points, PipeRunItems, PipeRuns, Components, Stream_Line_List, [Views], Drawings " \

                            f"from LINE_DATA_LIST a " \

                            f"join TitleBlockValues b on a.PNID_NO = b.Drawings_UID " \

                            f"join LineNoAttributes c on b.Drawings_UID = c.Drawings_UID " \

                            f"join Attributes d on c.Drawings_UID = d.Drawings_UID " \

                            f"join Associations e on d.Drawings_UID = e.Drawings_UID " \

                            f"join Points f on e.Drawings_UID = f.Drawings_UID " \

                            f"join PipeRunItems g on f.Drawings_UID = g.Drawings_UID " \

                            f"join PipeRuns h on g.Drawings_UID = h.Drawings_UID " \

                            f"join Components i on h.Drawings_UID = i.Drawings_UID " \

                            f"join Stream_Line_List j on i.Drawings_UID = j.Drawing_UID " \

                            f"join [Views] k on j.Drawing_UID = k.Drawings_UID " \

                            f"join Drawings l on k.Drawings_UID = l.[UID] " \

                            f"where l.[uid] = '{drawing.UID}'"

                    cursor.execute(sql)

                    '''

                if self.project.database.db_type == 'SQLite':

                    cursor.execute('commit')

                else:

                    conn.commit()