We can retrieve the identity for all tables in a database by using the below query:

SELECT  
  TABLE_NAME
, COLUMN_NAME
, IDENT_SEED(TABLE_NAME) AS "Identity Seed"
, IDENT_INCR(TABLE_NAME) AS "Identity Increment"
, COLUMN_DEFAULT
, DATA_TYPE
, IS_NULLABLE
, ORDINAL_POSITION
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMNPROPERTY(object_id(TABLE_NAME), COLUMN_NAME, 'IsIdentity') = 1
  AND TABLE_NAME != 'sysdiagrams'
ORDER by TABLE_NAME