I went to TOAD to find out how many views I had created in a certain DB. I needed this information for something that came up with TOAD Data Modeler.
TOAD reported that I had over 400 views(!), which was, indeed, news to me. Especially since I didn’t see anywhere near that many views listed. So, then I clicked on view details. It turns out that the number is including all of the system and information_schema views! The actual number of views, after copying to Excel (which was a problem - more on that later), was more like 52.
So, in the the View Details window, I selected all the cells that had a real (read: non-system) view. I then right-clicked to copy or export (to Excel). In every other grid I have ever used in TOAD, the contect menu allows me to select copy or export. For some reason, this time it didn’t. I could do compares, creates, alters, etc., but no simple Copy Cells or Export Grid. I was able to resolve the problem by clicking on Edit->Copy, which then let me copy the cells. I found the same behaviour in tables, as well.
First, my apologies for putting two (related) items into one post. Here they are, summarized:
- View count should only show non-system views. That was highly confusing to me for a short while. This would also make it behave like the table count.
- Please add Copy and Export options to the context menu when viewing details of high-level groupings of items, like all tables and all views.