# 查出DB裡table欄位有哪些是identity

select o.name, c.name
from sys.columns c inner join sys.objects o 
on c.object_id=o.object_id 
where c.is_identity = 1 and o.type='U'


就可以查出哪些table的哪個欄位是identity型態了