获取表自增列的信息

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(表名)

转载于:https://www.cnblogs.com/zyzhang/archive/2010/06/30/1768081.html