Versions

Inspect a past version

Opening a version shows the schema exactly as it was when the version was created. Use it to confirm what went into a release, review an incident, or show someone how an object used to look. You can also generate a deployment script from here.

In the app: Data Model › Schemas › your schema › Versions › a version number

[screenshot]
A version page with the blue "Version Snapshot v1.2.0 — Read Only" banner, the script-type picker, and the Tables tab.

Open a version

  1. Open the schema’s Versions page.
  2. Click a version number, or the eye icon on its card.

A blue banner at the top reads Version Snapshot v1.2.0 — Read Only. Click View Working Version → in the banner to return to the live schema.

Below the banner you see who created the version and when, its notes, and its change summary.

The tabs

Each tab shows its item count, for example Tables (24).

Tab Columns shown
Tables Table Name, Description, DB Schema, Columns, Modified
Views Name, Display Name, Description, DB Schema, Modified
Procedures Same as Views
Functions Same as Views
Enums Enum Name, Description, Values, Strategy

The Strategy badge on an enum shows ENUM when the enum is generated as a native enum type, or CHECK when it is generated as a check constraint.

Each row in the Tables, Views, Procedures, and Functions grids has an open-in-new icon (View working version). It opens the live object, not the snapshot.

Note: Standalone scripts are captured in the version but have no tab here.

Drill into an object

Click any name to open that object as it was in the version. Every object page repeats the read-only banner.

A table

  • Columns tab: Column Name (a key icon marks primary-key columns), Data Type, Nullable, Default, Description.
  • Indexes tab: Index Name, Type, Unique, Clustered, Description.

Relationships are captured in the version, and they show up in comparisons and generated scripts, but the table snapshot page does not list them.

A view, procedure, or function

Tabs appear only when they have content:

  • Output Columns: Column, Data Type, Nullable, Ordinal, Description.
  • Parameters: Parameter, Data Type, Direction, Nullable, Default, Description.
  • Scripts: one card per dialect with the SQL body as it was stored. The dialect you marked as primary carries a Primary badge.

An enum

The enum page shows the ENUM or CHECK strategy badge, the description, and a grid of values: # (sort order), Value, Description, and Active. Unlike the other snapshot pages, the enum page has no View Working Version → link. Use the browser’s back button or the breadcrumb to leave it.

Generate a script from this version

The top-right of the version page has a script-type picker and a Generate Script button. Pick Full Script, Create Objects, Load Script, or (for Databricks and Fabric Lakehouse schemas) Spark Schemas, then click Generate Script. See Generate a script from a version.

What you cannot do here

  • Edit anything. Every snapshot page is read-only.
  • Run SQL against a database. Generate a script and run it with your own tools.