Home/ Catalog

utilities

Vista Schema Search

Use this to search Vista stored procedures and tables via the generated catalogs. Prefer grep over opening the raw SQL dump.

Use this skill when you need to locate Vista stored procedure or table definitions without loading the 54 MB vista_schema_dump.sql. All catalogs are pre-sliced by schema for grep-friendly lookups.

Resources (cached catalogs)

  • Procedures: .github/skills/vista-schema-search/vista/procedures/schema-*.md
  • Tables: .github/skills/vista-schema-search/vista/tables/schema-*.md
  • Index/overview: .github/skills/vista-schema-search/vista/INDEX.md

How to search procedures

  1. Pick schema file (common: schema-dbo.md).
  2. List all procedures: grep "^### " .github/skills/vista-schema-search/vista/procedures/schema-dbo.md
  3. Find by name: grep "^### vspBatch" .github/skills/vista-schema-search/vista/procedures/schema-*.md
  4. Each entry has: name, source line in dump, full signature, first 3 SQL lines.

How to search tables

  1. Pick schema file (common: schema-dbo.md).
  2. List all tables: grep "^### " .github/skills/vista-schema-search/vista/tables/schema-dbo.md
  3. Find by name: grep "^### Employee" .github/skills/vista-schema-search/vista/tables/schema-*.md
  4. Columns show name, type, constraints (PK/FK/UNIQUE/NOT NULL); table constraints listed below.

Quick paths

  • Master index: .github/skills/vista-schema-search/vista/INDEX.md
  • Big catalogs: dbo procedures (221 KB), dbo tables (2454 KB). Avoid loading more than needed; prefer targeted grep.

Safety / performance

  • Never open C:\Users\dwise1\Downloads\vista_schema_dump\vista_schema_dump.sql directly; use the catalogs.
  • Avoid embedding large blocks from catalogs; quote only the needed rows.
  • If you need full text for a specific object, cite the line number from the catalog to extract narrowly from the dump.