IntelliJ IDEA 2019.1 Help

Cannot find a database object in the database tree view

If you see no objects below the schema level, cannot find changes in objects, experience broken tables or any other visualization problems, try the following steps to resolve the problem.

Step 1. Synchronize the database state

If someone changed the remote database data or view, the local view of the database might differ from the actual state of the database.

To synchronize the database state automatically, in the Database tool window (View | Tool Windows | Database), click the Data Source Properties button (the Data Source Properties button) and select the data source that you want to change. On the Options tab, select the Auto sync checkbox.

If the Auto sync checkbox is cleared, the view of the data source in the Database tool window (View | Tool Windows | Database) is synchronized with the actual state of the database only when you click the Synchronize icon (the Synchronize icon) or press Ctrl+Alt+Y.

Synchronize the database state

Step 2. Verify that the necessary schemas are selected

You can select what schemas you want to show in the database tree view.

  • In the Database tool window (View | Tool Windows | Database), right-click a data source and navigate to Database Tools | Manage Shown Schemas. Select or clear checkboxes of schemas that you want to enable or disable. Press Enter.

  • Click the N connections link near the data source name. Select or clear checkboxes of schemas that you want to enable or disable. Press Enter.

  • To hide all schemas, navigate to Database Tools | Hide Schemas.

Show and hide schemas

Step 3. Clear and synchronize the schema cache

Clear the IntelliJ IDEA schema cache (right-click a data source and select Database Tools | Forget Cached Schemas). Synchronize the view (see Step 1. Synchronize the database state).

Step 4. Switch to the JDBC-based introspector

To switch to the JDBC-based introspector, click the Data Source Properties button (the Data Source Properties button), select the Options tab, and then select the Introspect using JDBC metadata checkbox. Synchronize the view (see Step 1. Synchronize the database state). Consider this step as a temporary workaround.

Switch to the JDBC-based introspector
Last modified: 20 June 2019