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:
1. Execute sys.identity_columns view with select query
select * from sys.identity_columns
2. Executing sys.columns to see the inherited columns in sys.identity_columns
select * from sys.columns