Press "Enter" to skip to content

Discovering Nested References in SQL Server

Published 2024-08-29 by Kevin Feasel

Tom Zika is helping:

The original question lists these requirements:

  1. Information about all the tables referenced by a stored procedure
  2. Also, list tables from cross-DB query
  3. Return DB, Schema and Table names

Read on for a script to set up the example and then a query to build out these references.

Published in Administration and T-SQL