Different ways to find table name and Identity column name

 There are different methodology are available to validate/find list of table with Identity column names. I have got few have a look share any others way also to find out table name with identity columns detail.

Method 1# 

SELECT 
COLUMN_NAME, TABLE_NAME
FROM 
INFORMATION_SCHEMA.COLUMNS
WHERE 
TABLE_SCHEMA = 'dbo'
AND COLUMNPROPERTY(object_id(TABLE_NAME), COLUMN_NAME, 'IsIdentity') = 1
order by TABLE_NAME

Method 2#

SELECT 
o.name, c.name
FROM 
sys.objects o inner join sys.columns c 
on o.object_id = c.object_id
WHERE 
c.is_identity = 1 
AND type='U'
order by o.name 

Method 3#

SELECT 
object_name(object_id), name,*
FROM 
sys.columns
WHERE 
is_identity = 1  
AND user_type_id='56'

Method 4#

SELECT
    sys.objects.name AS table_name,
    sys.columns.name AS column_name
FROM sys.columns JOIN sys.objects
    ON sys.columns.object_id=sys.objects.object_id
WHERE
    sys.columns.is_identity=1
    AND
    sys.objects.type in (N'U')

Method 5#

SELECT 
SCHEMA_NAME(schema_id) AS schema_name
    , t.name AS table_name
    , c.name AS column_name
FROM sys.tables AS t JOIN sys.identity_columns c 
ON t.object_id = c.object_id
ORDER BY schema_name, table_name;