Tables with Identity Column

select distinct
    t.name
from
    sys.tables t
    inner join sys.columns c
        on t.object_id = c.object_id
        and c.is_identity = 1
order by t.name