Simple and Advanced view

You can control how the Database navigator and Database object editor display objects by switching between Simple and Advanced connection views.

navigator simple advanced view

To change the view, right-click a connection in the Database navigator and select Connection view:

  • Simple - shows only schemas and tables.
  • Advanced - shows all database objects. Enabled by default.
  • Show system objects - makes system schemas and tables visible in the Database navigator and the Metadata editor.

Tip

Admins can set the default view for all new connections in Settings - Server configuration - Configuration - Navigator simple view. This only affects newly created connections.