select tb.[name] TableName, ta.[name] ColumnName, ta.[object_id] FID, ta.is_identity, tb.[schema_id] from sys.all_columns ta
left join sys.all_objects tb on tb.[object_id] = ta.[object_id]
where tb.[schema_id]='1' and ta.is_identity=1
order by ta.is_identity, tb.name