SQL Identity – Catalog View – SQL Server

sys.Identity_columns : catalog view contains information for each identity column in a table in that database. This view contains identity column information such as seed, increment, last_value and etc. This view also contains information from the sys.columns view.

Basic column definition for sys.identity_columns vies as given below:

Example

1. Execute sys.identity_columns view with select query

use AdventureWorks2012

select * from sys.identity_columns
go

Output

2. Executing sys.columns to see the inherited columns in sys.identity_columns