List all table name with column value for a specific column name

Vote count:

0

Would anyone be able to help me out with this query. I'd need to list all table name with the max date value from a column name 'Extract_Date'. My query below only returns the list of all table name where there are column name 'Extract_Date' but I'm not sure how to list column value. Much appreciate.

select
    object_schema_name(t.object_id) + '.' + t.name as table_name,
    c.name as column_name
from sys.tables t
inner join sys.columns c
on t.object_id = c.object_id
where c.name like '%extract_date%'

asked 20 secs ago

Eric Tran

1

List all table name with column value for a specific column name