Identity Columns are used quite a bit in database.
SQL Server has a few functions dedicated to working with this datatype.
Here are some of those functions:
The IdentityCol allows one to reference an Identity Column without explicitly referring to that column by its name.
select max(IDENTITYCOL) from dbo.company
- Creating and Modifying Identifier Columns