Skip to content

First Steps

Connecting to a database

To work with a database, you first create a database connection. See Creating a Connection.

Viewing a table

To view a table:

  1. In the Databases tab, expand the connection until you see the table.
  2. Double-click the table to open it in an Object View tab.

    Database table view interface

The Object View tab has a number of sub-tabs. Which ones depend on the database. These are the most common:

Sub-tabDescription
InfoBrief information about the table.
ColumnsThe columns, with their data types and sizes.
DataThe table data. You can view and edit it here.
Row CountThe number of rows in the table.
Primary KeyThe primary key columns, if any.
IndexesThe indexes, if any.
GrantsThe privileges granted for the table.
DDLThe CREATE statement for the table. Only in DbVisualizer Pro.
ReferencesThe primary and foreign key relationships to other tables. See Viewing Table Relationships.
NavigatorBrowse the data through the relationships. Only in DbVisualizer Pro. See Navigating Table Relationships.

Editing table data

Only in DbVisualizer Pro

This feature is only available in the DbVisualizer Pro edition.

To edit the data in a table:

  1. In the Databases tab, expand the connection until you see the table.
  2. Double-click the table to open it in an Object View tab, and open the Data sub-tab.

    Editing data in a database table

  3. Edit values directly in the grid, and add or delete rows using the buttons in the toolbar.

  4. Click Save Edit(s) in the toolbar to save the changes to the database.

If the table has no primary key or unique index, you are asked to choose the columns that identify a row.

For more about editing data, see Editing Table Data.

Running SQL

To execute SQL statements:

  1. Select SQL Commander → New SQL Commander, or click New in the main toolbar.
  2. Select the database connection, and the catalog and schema to use. See Choosing the Connection, Database and Schema.
  3. Enter the SQL statements in the editor.
  4. Click Execute in the toolbar, or select SQL Commander → Execute.

The log and the results are shown in tabs below the editor.

An SQL Commander tab with results

For more about writing and executing SQL, see Working with SQL.

Creating a table

Only in DbVisualizer Pro

This feature is only available in the DbVisualizer Pro edition.

To create a table:

  1. In the Databases tab, expand the connection until you see the Tables node.
  2. Right-click the Tables node and select Create Table.

    Opening the Create Table dialog

  3. Add the columns and constraints in the corresponding tabs in the dialog.

  4. Click Execute to create the table.

Adding columns and constraints

For more about the Create Table dialog, see Creating a Table.