Controls whether query results are fetched again after deletes, updates, and inserts.

Allowed values

On, Off

Default

On

Remarks

If auto_refetch is On, the current query results that appear on the Results tab in the Interactive SQL Results pane are refetched from the database after any INSERT, UPDATE, or DELETE statement. Depending on how complicated the query is, this may take some time. For this reason, it can be turned off.

See also

• SET OPTION statement [Interactive SQL]