MySQL – cannot examine view definition – Error getting DDL for object – No database selected

Posted on

Question :

I have a view that I can run, it returns a dataset, but whenever I try to alter the view or look at its definition, I get

Error getting DDL for object
No database selected

enter image description here

But I do have a database selected and I can run the view with results.

How do I recover the definition? Please advise

Answer :

No database selected error message means that no database is selected as current. Specify default database in my.ini, connection definition, or execute USE dbname; as the very first query in the connection.

why no other view required a default schema be defined, and why is a default schema required at all? – Roy Hinkley

Default scheme needed when tablename without database name is specified somewhere in SQL text.

For example, you execute SHOW CREATE TABLE my_view – but without default datatbase set the server does not know where it must take this view from (and even does this is a table or a view).

Leave a Reply

Your email address will not be published. Required fields are marked *