Listing MySQL Views

Hello.

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

Regards,
Alexander.

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

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

Alexander.

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.

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.