Listing all the tables that contain the specified column name in SQL Server

Here’s a query that can be used to list all the table names that contain the specified column name from the INFORMATION_SCHEMA.Columns table.

SELECT COLUMN_NAME, TABLE_NAME 
FROM INFORMATION_SCHEMA.COLUMNS 
WHERE COLUMN_NAME LIKE '%ModifiedDate%'

image

Leave a Reply