Get List of All Auto Incremented Column Names in SQL Server

To get the Incremented column names in SQL Server of database table use the following query
 
  1. select *from sys.identity_columns