Skip to content
← dbForge Studio for MySQL

I suggest you...

dbForge Studio for MySQL

Categories

JUMP TO ANOTHER FORUM

(thinking…)

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
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Mike Taylor shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • AdminDevart (_, Devart) commented  ·   ·  Report

    Dear User,

    Thanks for your patience!

    We would like to inform you that a new version of the Studio has now been released, it includes a lot of features and fixes, including the issue you described.

    We kindly ask you to update to the latest version of the Studio and check the implementation of the functionality you described in this post.

    If the issue is still relevant, please let us know in detail by filling out the form on the company’s website (https://www.devart.com/company/contactform.html) or write directly to support@devart.com

    Best,
    Devart Team