SELECT

      TABLE_NAME,

      COLUMN_NAME,

      IDENT_SEED(TABLE_NAME) AS SEED,

      IDENT_INCR(TABLE_NAME) AS INCR,

      IDENT_CURRENT(TABLE_NAME) AS [CURRENT MAX]

FROM INFORMATION_SCHEMA.columns

WHERE COLUMNPROPERTY(OBJECT_ID(TABLE_NAME),COLUMN_NAME,'IsIdentity')=1