Code Inspection: Unresolved reference
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.Suppress an inspection in the editor
Position the caret at the highlighted line and press Alt+Enter or click
.Click the arrow next to the inspection you want to suppress and select the necessary suppress action.
Last modified: 16 July 2021