read invalid view
Cannot Edit Views if Column No Longer Exists. This was already asked before, but it still doesn't work. We still get "... references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them". This pops up all the time on complex projects and it's a pain to recover from with SELECT VIEWDEFINITION FROM INFORMATIONSCHEMA.VIEWS when you guys could just try this automatically whenever the error occurs.
3
votes
Mike Taylor
shared this idea