怎样找出列ID是是自动递增的表？
返回 table1，table2，table3
------解决思路----------------------
select name from sys.tables where object_id in (select object_id from sys.columns where name ='id' and is_identity=1)
------解决思路----------------------
select a.name from sys.tables a join sys.columns b on a.object_id=b.object_id
where b.is_identity=1
------解决思路----------------------
select OBJECT_NAME(object_id) 表名,
name 列名,
seed_value 起始值,
increment_value 增量,
last_value 下个值
from sys.identity_columns
order by 1