Listing MySQL Views

Hi everybody,

is there a way to see all views within a MySQL schema in the tree menu?
I didn't find anything here or on google. Do I miss something or is it a missing feature?

Greetings
Nils

5 comments
Comment actions Permalink

Hello.

All views in a schema should be shown under the schema node in Database tree view. Is there anything missing?

Regards,
Alexander.

0
Comment actions Permalink

Thanks for the fast reply.

Unfortunately the tree view just shows tables and stored procedures.

When I first started using 0xDBE with MySQL I had a quite similar problem with SPs. That time 0xDBE told me I needed select permission on the mysql.proc table, if I remember right. Maybe some kind of permission is needed for views as well.

The database is located on a different computer, and the user has full access to the schema i work with and the said select permission on mysql.proc.
I can show views by "SHOW CREATE VIEW ###" statement.

It seems that I have the needed rights, since I can get the View definition by statement. But still nothing in the tree menu.

Greetz
Nils

0
Comment actions Permalink

Thanks for the explanation. I'll pass the question to our developers.

Alexander.

0
Comment actions Permalink

To try it quickly: execute the following statement in 0xDBE console for the same datasource:

select table_name, table_schema, view_definition from information_schema.views;

Is it successful? Do you see your views in the query results?

Regards,
Alexander.

0
Comment actions Permalink

The posted query returns a ok-looking result. I get the view name, the schema name and the view definition sql.
So permissions seem to be ok for my user.

Greetings
Nils

Some addition:
I just discovered if I use the breadcrumb menu on the top of the screen and start navigating beginning from the "Database" item, I get the list of all in-schema items including the view. If I select the view, nothing happens exept I get two further options: "lastentry" and "magnitude". No matter which on I select, the breadcrumb jumps back to the "schema" item.

0

Please sign in to leave a comment.