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;

Find other useful SQL Server object details 

List Foreign Keys referencing tables in SQL Server

What are the triggers in SQL Server

How to find default values of all SQL Server columns

How to find computed columns on a SQL Server table

Find SQL Server LOB Columns