The Database Objects feature has been enhanced and are now based on a concept called Database Profiles

Please see the release notes for a detailed list of changes.

Database Profiles

A profile defines per database what information should be displayed in the database objects tree and in all object views. DbVisualizer Personal 4.1 adds specialized database profiles for Oracle, Sybase, Informix, DB2, SQL Server, MySQL and PostgreSQL.
All other databases use a generic profile which will list the same objects as in previous versions of DbVisualizer.

There is support to browse the source for triggers, stored procedures, functions and packages and also the select statement for views.

4.1 orapack

Oracle

The following objects are supported for Oracle databases: Standard Objects

  • Tables, Views
  • Synonyms
  • Indexes
  • Sequences
  • Materialized Views
  • Functions
  • Procedures
  • Packages
  • Triggers

DBA objects

  • Users
  • Roles
  • Table Spaces
  • Data Files
  • Rollback Segments
  • Sessions
  • Statistics
4.1 orapack

DB2

The following objects are supported for DB2 LUW databases: Standard Objects

  • Tables
  • Views
  • Aliases
  • Indexes
  • System Tables
  • Summary Tables
  • Functions
  • Stored Procedures
  • Packages
  • Triggers

DBA objects

  • Users
  • Groups
  • Table Spaces
4.1 orapack

SQL Server

The following objects are supported for SQL Server databases: Standard Objects

  • Tables
  • System Tables
  • Views
  • Indexes
  • Users
  • Groups
  • User Defined Data Types
  • Triggers
  • Stored Procedures

DBA objects

  • Server Info
  • Logins
  • Database Devices
  • Remote Servers
  • Processes
  • Roles
  • Locks
4.1 orapack

Informix

The following objects are supported for Informix databases: Standard Objects

  • Tables
  • System Tables
  • Views
  • Indexes
  • Triggers
  • Functions
  • Procedures
  • Sequences
  • Data Types
  • Users
  • Roles

DBA objects

  • Server Info
  • Sessions
  • Spaces
4.1 orapack

Sybase ASE

The following objects are supported for Sybase ASE databases: Standard Objects

  • Tables
  • System Tables
  • Views
  • Users
  • Groups
  • User Defined Data Types
  • Triggers
  • Stored Procedures

DBA objects

  • Server Info
  • Logins
  • Database Devices
  • Remote Servers
  • Processes
  • Roles
  • Transactions
  • Locks
4.1 orapack

PostgreSQL

The following objects are supported for PostgreSQL databases: Standard Objects

  • Index
  • Sequence
  • System Index
  • System Table
  • System Toast Index
  • System Toast Table
  • System View
  • Table
  • Temporary Index
  • Temporary Table
  • View
  • Functions

DBA objects

  • Users
  • Groups
  • Settings
  • Locks
  • Sessions
4.1 orapack

MySQL

The following objects are supported for MySQL databases: Standard Objects

  • Tables

DBA objects

  • Users
  • Sessions
  • Status
4.1 orapack

To see all changes in DbVisualizer 4.1, please see the Release Notes.

Cookie policy

We use cookies to ensure that we give you the best experience on our website. However you can change your cookie settings at any time in your browser settings. Please find our cookie policy here ↗