try this and let me know

Line "and Parent.user_type_id =36" is for uniqueidentifier

and

Line "AND Child.is_identity+1=Parent.is_identity"(which is comment in this query) is for column which is

identity column in primary table

run this and let me know result

;WITH CTE AS

(

select TAB.object_id,TAB.name,COL.name AS COLNAME,COL.column_id,COL.is_identity ,col.user_type_id

from

sys.tables TAB

INNER JOIN sys.columns COL ON TAB.object_id=COL.object_id

)

SELECT

Child.object_id as 'Child Objectid'

,Child.name as 'Child TableName'

,Child.COLNAME as 'Child ColumnName'

,Parent.object_id as 'Parent Objectid'

,Parent.name as 'Parent TableName'

,Parent.COLNAME as 'Parent ColumnName'

FROM

cte Child

INNER JOIN CTE Parent

ON Child.COLNAME=Parent.COLNAME AND Child.name<>Parent.name

--AND Child.is_identity+1=Parent.is_identity

and Parent.user_type_id =36