Database Schema

Use the Query Console sidebar to browse database metadata.

Table browser

The Tables area lists tables in the current database or schema. Search to filter the list and refresh metadata when the database changes. Select Load details for a table to view columns, data types, lengths, nullability, primary keys, indexes, and constraints.

Schema tools

From the Tables menu, you can:

• Create a table with a visual DDL designer
• Add columns to an existing table
• Visualize tables and relationships in Schema Graph
• Export table structures to another connection

Stored procedures

Expand Stored procedures to browse available procedures, inspect parameters, and generate a CALL statement. The procedure editor is available for DB2 and AS/400 (DB400) connections.