获取表自增列的信息
Select so.name Table_name,
sc.name Iden_Column_name, ----自增列名称
ident_current(so.name) curr_value, -----改列当前的值
ident_incr(so.name) incr_value, ---开始值
ident_seed(so.name) seed_value ---增幅
from sysobjects so
Inner Join syscolumns sc
on so.id = sc.id
and columnproperty(sc.id, sc.name, 'IsIdentity') = 1
Where upper(so.name) = upper(表名)
sc.name Iden_Column_name, ----自增列名称
ident_current(so.name) curr_value, -----改列当前的值
ident_incr(so.name) incr_value, ---开始值
ident_seed(so.name) seed_value ---增幅
from sysobjects so
Inner Join syscolumns sc
on so.id = sc.id
and columnproperty(sc.id, sc.name, 'IsIdentity') = 1
Where upper(so.name) = upper(表名)