Get The Details Of Identity Columns in a Table in sql server
To get the current value: SELECT IDENT_CURRENT('Table Name') As currentValue To get the Identitity seed: SELECT IDENT_SEED('Table Name')As identitySeed To get the Identity Increement SELECT IDENT_INCR('Table Name') As IdendityIncreement