InterSystems IRIS and Caché ship a great many useful system objects. Connect with a generic SQL client and you get all of them at once, which makes finding your own three schemas an exercise in scrolling.
Recognise that view?
Clear one checkbox
In SQL DATA LENS the system objects are a property of the connection. Open the connection properties and clear Show system objects.
Reconnect, and the Server Navigator shows your own tables, views, classes and routines — nothing else.
The related options
Two neighbouring options are worth knowing about, because they filter different things:
- Show system objects hides system schemas such as
%Libraryfrom the object lists. This is the one you usually want off. - Show system namespaces hides namespaces such as
%SYSfrom the tree. Turn it on when you are doing administrative work, off when you are developing.
Both are per connection, so you can keep an administrative entry for a server with everything visible and a working entry for the same server with the noise removed. The full list of connection options is in setting up a connection to InterSystems IRIS or Caché.
The filter applies to the views built on the tree as well: the Table Viewer and the class viewer list what the connection shows, so the setting follows you through the whole application. Some functions deliberately ignore it — database diagrams, for instance, can include system objects when the connection asks for them.
Try it against your own namespace with the build on the download page.