UFN_AUDITHELP_GETSAMERELATIONFKCOLUMNINFO

                    create function [dbo].[UFN_AUDITHELP_GETSAMERELATIONFKCOLUMNINFO]
                        (@SOURCETABLENAME nvarchar(128))  --name of source table to get FK column info about.)
                    returns nvarchar(255)
                    with execute as caller
                    as begin
                        return (select top 1 COLUMN_NAME
                                from INFORMATION_SCHEMA.COLUMNS 
                                where 
                                    (TABLE_SCHEMA = 'dbo') 
                                    and (TABLE_NAME = @SOURCETABLENAME)
                                    and dbo.UFN_SCHEMA_GETPARENTTABLENAME(@SOURCETABLENAME,COLUMN_NAME) = @SOURCETABLENAME
                                    and DATA_TYPE='uniqueidentifier' 
                                    and COLUMN_NAME not in ('ID', 'TS', 'TSLONG')
                                )
                    end