delete without where not possible
Answered
Yesterday i wanted to delete all content of a table and tried to execute the command "delete from <tablename>" in the console. Datagrip prohibit this with a warning "Unsafe query: 'Delete' statement without 'where' clears all data in the table". This is quite good to prevent accidentially deletion. But there is no option to overwrite this behavior. I have to add a dummy "where 1=1" to get the statement executed. I would like to see a dialog box instead with the warning and the possibility to delete the data anyway.
Kind Regards
Andreas
Please sign in to leave a comment.
You should see a yellow note at the bottom of console like this:
and here are 2 options - `execute` & `execute and suppress` (this one disables warning forever)
How to enable it back. If I click `execute and suppress` once.
Gwalke20, Preferences/Settings | Database | Query Execution | Show warning before running potentially unsafe queries.
Thank you for the hint. I have missed the two links because in full screen mode the hint is a one liner and the links are placed on the far right. Also the contrast between foreground and background is a bit weak. I should better use a light color theme. There the contrast is better.
Kind Regards
Andreas
Hi Yuriy,
Is there a way of disabling this warning on a per query basis, rather than disabling the check forever?
i.e.
Steven Pearce,
There is no such an option. Could you file an issue in DataGrip YouTrack?