SQLServer – DataType – Identity Columns


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.


Sample Code:

select max(IDENTITYCOL)
from   dbo.company


  1. Creating and Modifying Identifier Columns

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s