LocalDict

Build your data dictionary

Everything happens in this tab. Your pasted metadata is never uploaded; the page's security policy blocks it from talking to any server other than this site, and the only call it ever makes is a license-key check.

1. Run the catalog query

It reads only system catalog views (sys.tables, sys.columns, sys.key_constraints, sys.foreign_keys, sys.extended_properties…). No row data. SQL Server 2016+ and Azure SQL.

Download query.sql

In SSMS: run it, click the grid, Ctrl+A, right-click → Copy with Headers. That's the recommended format. Quoted CSV and JSON (FOR JSON PATH) also work. SSMS's "Save Results As CSV" doesn't quote values by default, so commas in descriptions would break it; use Copy with Headers instead.

2. Paste the results

Pro: unlimited tables

The free version documents up to 15 tables. A Pro license ($24, one-time) removes the limit.

Buy Pro, $24

Already bought? Paste the license key from your Gumroad receipt: