Inspectopedia
 
2024.3

Statement with side effects

Warning
Last modified: 03 December 2024

Reports statements that might lead to modification of a database during a read-only connection.

To enable read-only mode for a connection, right-click a data source in the Database tool window (View | Tool Windows | Database) and select Properties. In the Data Sources and Drivers dialog, click the Options tab and select the Read-only checkbox.

Example (MySQL):

As CREATE TABLE and INSERT INTO statements lead to a database modification, these statements will be highlighted in read-only connection mode.