--查询数据表的所有列
select c.name as 列名 from dbo.sysobjects t inner join sys.identity_columns c on t.id = c.object_id
where t.xtype = 'U'
--查询数据表的所有列
select c.name as 列名 from dbo.sysobjects t inner join sys.identity_columns c on t.id = c.object_id
where t.xtype = 'U'