Table Designer

The Table Designer provides a visual interface for creating and modifying database tables without writing DDL.

Opening Table Designer

Create New Table

1. Right-click a schema in the sidebar
2. Select New Table
3. A new Table Designer tab opens

Edit Existing Table

1. Right-click a table in the sidebar
2. Select Design Table
3. The Table Designer loads the existing structure

Designer Interface

Table Settings

Columns Section

Add, edit, and reorder columns:

Column Actions

• Add Column - Add a new column
• Duplicate - Copy an existing column
• Delete - Remove a column
• Reorder - Drag and drop to change order

Data Types

Types are grouped by category:

Numeric

• smallint, integer, bigint
• serial, bigserial
• numeric, decimal
• real, double precision
• money

Text

• char(n), varchar(n), text
• bytea

Date/Time

• timestamp, timestamptz
• date, time, timetz
• interval

Boolean & UUID

• boolean
• uuid

JSON

• json, jsonb

Arrays

• Any type with [] suffix (e.g., integer[], text[])

Default Values

Choose from three types:

Constraints

Primary Key

• Check PK on columns to include
• Composite keys supported (multiple columns)
• Or add via Constraints section

Foreign Keys

1. Click Add Constraint → Foreign Key
2. Select local column(s)
3. Select referenced table and column(s)
4. Choose referential actions:
   • ON DELETE: CASCADE, RESTRICT, SET NULL, SET DEFAULT, NO ACTION
   • ON UPDATE: CASCADE, RESTRICT, SET NULL, SET DEFAULT, NO ACTION

Unique Constraints

1. Click Add Constraint → Unique
2. Select column(s) to be unique

Check Constraints

1. Click Add Constraint → Check
2. Enter the check expression (e.g., price > 0)

Indexes

Add indexes for query performance:

Preview SQL

Click Preview SQL to see the generated DDL:

CREATE TABLE public.products (
  id SERIAL PRIMARY KEY,
  name VARCHAR(255) NOT NULL,
  price NUMERIC(10,2) NOT NULL CHECK (price > 0),
  created_at TIMESTAMPTZ DEFAULT now()
);

CREATE INDEX idx_products_name ON public.products (name);

Saving Changes

Create Mode

Click Create Table to execute the CREATE TABLE statement.

Edit Mode

Click Save Changes to execute ALTER TABLE statements for your modifications.

Discarding Changes

Click Discard to reset to the original state (or empty for new tables).

Validation

The designer validates your design:

• Table name is required
• At least one column required
• Unique column names
• Valid constraint references
• FK columns match referenced columns

Errors appear in the validation panel at the bottom.