Error encountered when performing Introspect the Portion of idea Introspect using JDBC metadata在哪设置

前言

使用idea2025专业版（MAC）连接mySQL后无法显示表结构，并且报错

Error encountered when performing Introspect the Portion of 1 schema (full)) on level 1: Unknown table cf_reimb_paperless.tables.
Unknown table cf_reimb_paperless.tables.
Table 'cf_reimb_paperless.tables' doesn't exist.
Unknown table cf_reimb_paperless.procs_priv.
Unknown table cf_reimb_paperless.column_privileges.

解决

网上大部分解决方案均指向idea Introspect using JDBC metadata这个按钮打✅，但是找了半天，并没有在option找到这个按钮在哪；无奈只能查看idea官方文档
Data Sources and Drivers dialog直接检索了关键字，出现2条，看到了合适的是这个
文中末尾给了提示，放到了Advanced标签下

Temporarily enable introspection with JDBC metadata
Open data source properties by doing one of the following:
On the Database tool window toolbar, click The Data Sources icon Data Sources.
Open the Data Source and Drivers dialog
On the Data Sources tab, select the data source that you want to modify.
Open the Advanced tab.
From the Expert options list, select the Introspect using JDBC metadata checkbox.
Synchronize the view (see Step 1. Synchronize the database state).

MAC版本准确位置👇