def METHOD_NAME(cursor, target_table):
    if "." in target_table:
        schema_name, _ = target_table[: target_table.index(".")], target_table[target_table.index(".") + 1 :]
    else:
        schema_name = "public"
    # read the existing indexes of source table
    cursor.execute(make_read_indexes(target_table)[0])
    src_indexes = dictfetchall(cursor)
    # build the drop index sql
    drop_ix_sql = []
    for src_ix_dict in src_indexes:
        src_ix_name = src_ix_dict["indexname"]
        drop_ix_sql.append(f"DROP INDEX IF EXISTS {schema_name}.{src_ix_name}")
    return drop_ix_sql