Show SQL Server database table details. Including row counts, object ID's and last modified time stamps.

select o.object_id,
    o.name,
    o.type,
    o.create_date,
    o.modify_date,
    t.lock_escalation,
    CAST(ep.value as nvarchar(max)) as comment,
    ct.is_track_columns_updated_on,
    st.row_count
from sys.all_objects as o
left join sys.schemas as s
    on o.schema_id = s.schema_id
left join sys.tables as t
    on o.object_id = t.object_id
left join sys.extended_properties as ep
    on o.object_id = ep.major_id
       and ep.class = 1
       and ep.minor_id = 0
       and ep.name = 'MS_Description'
left join (select object_id,
               SUM(ROWS) as row_count
           from sys.partitions
           where index_id < 2
           group by object_id) as st
    on o.object_id = st.object_id
left join sys.change_tracking_tables as ct
    on o.object_id = ct.object_id
where o.type = 'U'
order by o.name;