Dbeaver Db2



This article will show you how you can use DBeaver (a free database tool for most popular databases) to see and update table comments.

View comments

First you need to connect to your database (I assume you already know how to do it).

Then use Database Navigator to find the table.

  1. DB2 (3) DB2 (3) Search. 1487 Solutions and counting. DBeaver is free universal SQL client/database tool for developers and database administrators. It can work with any database server which has JDBC or ODBC driver. It supports pluggable extensions.
  2. And this is not some kind of JDBC driver abstraction – DBeaver EE supports all native data types and databases structure explorer for these databases. DBeaver EE comes with all existing extensions, you don’t need to install anything else.
  3. DBeaver is a universal database management tool for everyone who needs to work with data in a professional way. With DBeaver you are able to manipulate with your data like in a regular spreadsheet, create analytical reports based on records from different data storages, export information in an appropriate format.

Double click table to open Table Editor.

Table commens are visible in top section in Description field under General in Properties tab.

Dbeaver Db2 System

DBeaver was migrated to Eclipse platform 2020-12 DBeaver build system was migrated to Tycho 2.0 Many minor UI bugs were fixed Note: if you experience any problems starting dbeaver after the version upgrade please try to reset workspace. DBeaver vs DbVisualizer: What are the differences? What is DBeaver? A Universal Database Tool. It is a free multi-platform database tool for developers, SQL programmers, database administrators and analysts. Supports all popular databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, Teradata, MongoDB, Cassandra, Redis, etc.

Column comments are visible in Comment colum in Columns tab in the bottom part of editor.

Edit commnets

To edit comments simply edit text in comment fields and save changes with ctrl + s or Save button in the toolbar at the bottom.

Before applying changes you will see script that and you need to accept it with Persist button.

Dbeaver Db2 Z/os

Bonus: Share database schema with comments in HTML

Exploring schema is easy with Dbeaver. But it can be even better with searchable and interactive HTML documentation generated with with Dataedo. Here is a sample documentation:

DBeaver 21.0.3

Dbeaver db2 ssl
  • Dark theme support was improved (Windows 10 and GTk)
  • Data viewer:
    • Copy As: format configuration editor was added
    • Extra configuration for filter dialog (performance)
    • Sort by column as fixed (for small fetch sizes)
    • Case-insensitive filters support was added
    • Plaintext view now support top/bottom dividers
    • Data editor was fixed (when column name conflicts with alias name)
    • Duplicate row(s) command was fixed for multiple selected rows
    • Edit sub-menu was returned to the context menu
    • Columns auto-size configuration was added
    • Dictionary viewer was fixed (for read-only connections)
    • Current/selected row highlighting support was added (configurable)
  • Metadata search now supports search in comments
  • GIS/Spatial:
    • Map position preserve after tiles change
    • Support of geometries with Z and M coordinates was added
    • Postgis: DDL for 3D geometry columns was fixed
    • Presto + MySQL geometry type support was added
    • BigQuery now supports spatial data viewer
    • Binary geo json support was improved
    • Geometry export was fixed (SRID parameter)
    • Tiles definition editor was fixed (multi-line definitions + formatting)
  • SQL editor:
    • Auto-completion for objects names with spaces inside was fixed
    • Database objects hyperlinks rendering was fixed
  • SQL Server: MFA (multi-factor authentication) support was added
  • PostgreSQL: array data types read was fixed
  • Oracle: indexes were added to table DDL
  • Vertica: LIMIT clause support was improved
  • Athena: extra AWS regions added to connection dialog
  • Sybase IQ: server version detection was improved
  • SAP ASE: user function loading was fixed
  • Informix: cross-database metadata read was fixed
  • We migrated to Eclipse 2021-03 platform
Posted in Releases