Code Inspection: Unresolved reference
Configure inspections: Settings | Editor | Inspections
Show intention actions: AltEnter
Reports unresolved SQL references.
Example (MySQL):
CREATE TABLE users(id INT, name VARCHAR(40));
CREATE TABLE admins(id INT, col1 INT);
SELECT users.id, admins.id FROM admins WHERE admins.id > 1;
The users.id
column is unresolved because the users
table is missing in the FROM clause.
Place the caret at the highlighted line and press AltEnter or click
.
Click the arrow next to the inspection you want to suppress and select the necessary suppress action.