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
But I do have a database selected and I can run the view with results.
How do I recover the definition? Please advise