How to find all identity columns in SQL Server

Question: How to find all identity columns in SQL Server?

Answer: 

USE myDB;
SELECT 
  SCHEMA_NAME(o.schema_id) AS [schema],
  OBJECT_NAME(idc.object_id) AS [object],
  o.type_desc,
  idc.name,
  idc.seed_value,
  idc.increment_value,
  idc.last_value
FROM sys.identity_columns idc 
INNER JOIN sys.objects o 
ON o.object_id = idc.object_id
ORDER BY SCHEMA_NAME(o.schema_id) ASC;