Code Inspections in SQL
This inspection performs unresolved SQL references check.
This inspection performs type-related check.
This inspection performs unused argument/variable check.
Identifier should be quoted
This inspection performs SQL identifier names check.
This inspection checks that column reference resolves to a single column
VALUES clause cardinality
This inspection checks that the number of VALUES (...) parameters matches target table column list size
SQL dialect detection
Detects the best matching SQL dialect for files in <Generic> dialect.
SQL source modification detection
Detects that database sources have changed.
No data sources configured
Prompts one to create a data source if there is none.
Each derived table should have alias
This inspection checks that each derived table should have own alias.
Column should be in group by clause
This inspection checks that column should be in group by clause or inside aggregate function call.
This inspection reports those conditions in the where or join clauses that are always true or false.
This inspection checks auto_increment duplicates in MySQL, MS SQL and DB2 dialect. A table in those dialects can contain only one auto-incrementing field.
Index is dependent on column
This inspection checks dropping indexed columns in MS SQL and Sybase SQL Server.
Adding not null column without default value
Necessary to specify the default value for the new column with not null constraint.
Check using clause columns
This inspection checks that columns inside using clause exist in both tables.
This inspection checks suspicious comparisons with NULL.
This inspection performs function signature check.
Statement with side effects
This inspection only runs during a read-only connection and reports statements that may lead to modification of the database
Provides diagnostic of MySQL parser idiosyncrasies
Since 8.0 the 'long' type is deprecated and not recommended to use (because API for this type doesn't utilize character streams but transfer whole values each time). In Oracle, do not create a table with LONG columns. Use LOB columns (CLOB, NCLOB, BLOB) instead. LONG columns are supported only for backward compatibility.
Select from procedure call
Select from dblink or function that returns record require typed alias list.Scalar functions do not require alias and forbid typed alias lists completely.