SELECT
s.name,
h.*,
p.last_updated,
p.rows,
p.rows_sampled,
p.steps,
p.unfiltered_rows,
p.modification_counter,
p.persisted_sample_percent
FROM sys.tables AS t
JOIN sys.stats AS s
ON t.object_id = s.object_id
OUTER APPLY sys.dm_db_stats_histogram
(
t.object_id,
s.stats_id
) AS h
OUTER APPLY sys.dm_db_stats_properties
(
t.object_id,
s.stats_id
) AS p
WHERE t.name = N't1'
AND h.stats_id IS NULL;