Searching for a Specific Table Column Across All Databases in SQL Server

To find tables with a specific column in a SQL Server database, use INFORMATION_SCHEMA.COLUMNS. For all databases, use a cursor to search and display results.

Read more