Truncate table in DBeaver right click menu/GUI

Question

I am trying to find an option to truncate table in the right click menu or somewhere in the GUI of DBeaver. The database is SQL Server.

Is there any other option rather that explicitly writing the truncate script?

Right click on table name -> tools -> truncate (at least with Postgres) — rogerdpack, Nov 02 '20 at 16:53

Volex · Answer 1 · 2021-03-09T10:43:53.180

14

In DBeaver 7.2.4 - Right click on a table, that needs to be truncated, choose Tools->Truncate, click 'Start'. That's all.

edited Mar 09 '21 at 10:43

answered Nov 13 '20 at 10:36

Volex

The Truncate option does not show up in that menu for me. – Adrian Keister Feb 16 '21 at 20:26
It did showed up for me, I guess you have to highlight the table first then in the top bar menu Database -> Tools -> Truncate – Dr Jfrost Feb 17 '21 at 22:39
DBeaver 7.3.5, there's no "Truncate" option in "Tools" – kev Feb 23 '21 at 18:00

score 2 · Answer 2 · answered May 23 '19 at 12:36

2

This feature is not yet available for SQL Server. May be DBeaver will include this in their new versions.

answered May 23 '19 at 12:36

RadAl

exactly this is the right answer. for SQL Server it's surprisingly not available... – Alexandre Dumont Oct 07 '22 at 08:33

2 Answers2