Create, Alter, and Visualize Tables

Create a table

From the Tables menu, select Create Table. Enter a table name and optional schema, then add columns with data type, length or precision, scale, nullability, primary-key designation, and default value. Generate the CREATE TABLE statement, review it in the editor, and execute it.

Alter a table

Right-click a table and select Alter Table. Existing columns are displayed read-only. Add new columns, generate ALTER TABLE ... ADD COLUMN statements, review, and execute them.

OL DataIQ formats generated DDL for the connected database.

Schema Graph

Select Schema Graph from the Tables menu to explore tables as nodes and relationships as edges. Pan and zoom large schemas. The graph displays columns, types, key indicators, foreign keys, and optionally inferred relationships such as _id naming patterns.