PhpStorm 2024.1 Help

Code Inspection: SQL source modification detection

Reports situations when source code of a database object has been changed.

The inspection is triggered when you perform database or object introspection. The introspection is run when you open source code of an object, run statements, and perform code refactoring. Also, you can run introspection by right-clicking an object and selecting Refresh.

The inspection covers the following situations:

  • Object source code was changed in the database but code in the editor was not updated. Works in PostgreSQL, Microsoft SQL Server, Oracle, and Sybase ASE.

  • You changed the object source code, introspected the database, but source code has been already changed by someone else.

  • The database introspector was updated in the IDE and you need to download new object properties that were missing in the previous introspector version.

Suppress an inspection in the editor

  1. Place the caret at the highlighted line and press Alt+Enter or click the Intention action icon.

  2. Click the arrow next to the inspection you want to suppress and select the necessary suppress action.

Last modified: 11 February 2024