Explore Vista Schema and Generate SQL
Use Schema Visualizer to browse Vista tables, place them on a canvas, inspect columns and joins, and copy generated SQL. This page does not execute SQL.
Where: Mission Control → SQL Studio → Schema Visualizer
Route: /missioncontrol/sql/schema-visualizer
To run a copied SELECT / WITH statement, paste it into Write, run, and save SQL queries. See SQL Studio workflow.
Add tables to the canvas
- Open Schema Visualizer.
- Click Add table (top-left +) to open the left Tables sidebar.
- Use Search tables... if needed, then click a row (
{code} — {name}).
The table node appears on the canvas with columns. Canvas layout persists in this browser until you clear it.
Legend (bottom of canvas): Primary Key, Identity, Required, Optional.
Explore a table node
| Control | Use |
|---|---|
| Click node surface | Opens the right panel for that table (Properties + SQL) |
| Click a column | Opens Column Properties for that column |
| Sort control | Cycles Sorted: ordinal → Sorted: A–Z → Sorted: Z–A |
| Remove table | Removes that node (no confirm) |
| Column link (Show available joins) | Menu of related tables: {targetTable} ON {joinCondition} — pick one to add the related table and connection |
Hover a join edge for Copy join condition.
Canvas tools (bottom-right): Fit view, Zoom out, Zoom in, Disable interactions / Enable interactions.
Table Properties and SQL (copy)
Select a table to open the right panel.
Properties
Read-only fields when present: Alias, Module, Company Column, HQ Join, Vista Form, Date Column, Identity Column, Primary Keys, Business Description.
SQL sections
Each section has a copy control. Toggle options apply only to that section’s generated text.
| Section | Notes |
|---|---|
| SELECT * | Options: Use alias, Security join, Company filter (Off → Auto → @Company), date filter (Current Month / Last Month / Current Year / Clear Date Filter) |
| SELECT columns | Same options plus Columns layout (inline / rows) |
| INSERT (all except identity) | Layout + Value mode (@ parameters / default values) |
| INSERT (PK + required) | Same |
| UPDATE by PK / UPDATE by Identity | Toggle WHERE mode (title flips between Use identity and Use primary keys) |
| DELETE by PK / DELETE by Identity | Same WHERE toggle |
INSERT / UPDATE / DELETE text is for copy only. SQL Studio will not run them in the editor.
Use Expand all / Collapse all on the SQL header to open or close sections.
Column Properties
Click a column on a node. The right panel shows Column Properties (Name, Alias, Type, Data type, Input mask, Length, Purpose, Required, Sort order when available). Empty: No columns available.
Canvas SQL (multi-table)
- Add the tables you need (and joins if you want connected SQL).
- Click Canvas SQL (top-left toolbar).
- Subtitle: All tables on canvas. If nothing is on the canvas: Add tables to the canvas to generate SQL.
- When the canvas has multiple disconnected clusters, pick a group (
Group {n}/{m} ({x} tables)); use Previous group / Next group or Select group. - Under SQL, copy SELECT * or SELECT columns with the same alias / security / company / date / layout toggles as the single-table panel.
Paste a SELECT into SQL Editor to run it.
Clear the canvas
- Click Clear canvas (trash, top-left).
- Confirm Clear canvas? → Clear (or Cancel).
This removes all tables and connections from the canvas (and clears the browser-saved layout).
Typical sequence
- Add table → search → click tables onto the canvas.
- Use Show available joins to pull in related tables.
- Select a table → tune SELECT options → copy, or open Canvas SQL for a multi-table SELECT.
- Paste into SQL Editor and Run SQL.
- Clear canvas when you are done with that diagram.