怎样找出列ID是是自动递增的表？

[zzxap]

怎样找出列ID是是自动递增的表？
返回 table1，table2，table3

[wtujedp]

select name from sys.tables where object_id in (select object_id from sys.columns where name ='id' and is_identity=1)

[發糞塗牆]

也就是找出列属性有identity的？

[霜寒月冷]

select a.name from  sys.tables a  join sys.columns b on a.object_id=b.object_id
where b.is_identity=1

[frankl123]

百度下syscolumns跟sysobjects

[卖水果的net]

select OBJECT_NAME(object_id) 表名,
       name 列名,
       seed_value 起始值,
       increment_value 增量,
       last_value 下个值
  from sys.identity_columns
 order by 1