Start Today

← Features

Schema browse and edit

Browse tables, columns, keys, indexes, and stored procedures; visualize schema graphs; generate CREATE/ALTER TABLE DDL; edit DB2/AS400 procedure source.

OL DataIQ provides schema exploration and DDL assistance beside the Query Console so teams understand and evolve database structure without leaving the app.

Capabilities

Browse

  • Table list with search/refresh; column, primary key, index, and constraint details
  • Stored procedure list with parameters and generated CALL statements
  • Interactive schema graph with foreign keys and optional relationship inference

Edit / generate

  • Visual Create Table and Alter Table designers that emit database-specific DDL into the console
  • Stored Procedure Editor for DB2 and AS/400 (DB400) to view and save procedure DDL
  • Schema export to create table structures on a target connection

Availability

  • Maturity: ga
  • SP Editor: DB2 and AS/400 (DB400) only
  • Product help: DataIQ User Guide: Database Metadata & Schema

Read more