Find Lookup Tables
find_lookup_tablesAutomatically identifies reference or lookup tables in a SQL Server database by analyzing table patterns and row counts. Specify schema and maximum rows to filter results.
Instructions
Identify reference/lookup tables automatically based on table patterns
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schema | No | Schema name (default: dbo) | |
| maxRows | No | Maximum rows to consider as lookup table (default: 1000) | |
| connectionName | No | Named connection to use (e.g., 'production', 'staging') |