CODEWITHSUNDEEP
sqldbeaver
jt4ever
jt4ever

Reputation: 65

DBeaver SQL is there a option to revert your query?

I'm pretty new to DBeaver and was wondering if it had an option to revert queries that were previously ran? For instance I ran

ALTER TABLE case_arrest_forms DROP CONSTRAINT cri_arrest_dispositionsid_fkey;

From the top menu it says it's on auto-commit. Is there a way for me to roll this back or would I have to add the constraint again? Any other suggestions?

Upvotes: 3

Views: 25829

Answers (1)

LonWo
LonWo

Reputation: 411

Nope, DBeaver doesn't have such kind of functionality. Can't revert query in auto-commit mode. Also, it is not possible to return the row deleted from the table.

But to avoid such situations, you can change the level of transactions.

Upvotes: 2

Related Questions