Cannot find a database object in the database tree view

Last modified: 08 March 2021

This is a Professional feature: download PyCharm Professional to try.

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.

note
If steps 1, 2, and 3 did not resolve your problem, inform JetBrains of your situation by creating a Youtrack ticket. After you have created the ticket, try steps 4 and 5 as a workaround.

Step 1. Refresh 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 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 Refresh icon or press Ctrl+F5.

Step 2. Verify that the necessary schemas are selected

note
If you see no schemas in the popup, check whether a connection to a data source is available. Refer to this troubleshooting article or report the situation to us.

When you create a data source, the data source is created with no schemas selected. You need to select schemas with which you plan to work.

The Default schema or Default database is a schema or a database that will be current on connection to a data source. The current schema is a schema that is current in a session. You can change the current schema by using SET CURRENT_SCHEMA. The default schema depends on database settings and data source settings that you set in the JDBC URL.

You can change this default in connection settings of a data source. To change the default, click the Data Source Properties icon in the Database tool window (View | Tool Windows | Database). In the data sources list, select your data source. In the Database field, type the name of a schema or a database that you want to use as a default.

To display a schema in the Database tool window, perform one of the following actions:
- 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 of N link near the data source name. In the schema selection window, 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.

Step 3. Force refresh schema information

The Force Refresh action clears the data source information from cache and loads it again from scratch.

In the Database tool window (View | Tool Windows | Database), right-click a data source and select Database Tools | Force Refresh.

Step 4. Clear and synchronize the schema cache

Clear the PyCharm 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 5. Switch to the JDBC-based introspector

warning
Switch to the JDBC-based introspector with caution. This step may lead to problems with code generation because some objects and properties become unavailable or return wrong values.

To switch to the JDBC-based introspector, click 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.

Cannot find a database object in the database tree view﻿

note

Step 1. Refresh the database state﻿

Step 2. Verify that the necessary schemas are selected﻿

note

Step 3. Force refresh schema information﻿

Step 4. Clear and synchronize the schema cache﻿

Step 5. Switch to the JDBC-based introspector﻿