USP_AUDITHELP_GETFKCOLUMNINFO

create procedure dbo.USP_AUDITHELP_GETFKCOLUMNINFO
(
@SOURCETABLENAME nvarchar(128)  --name of source table to get FK column info about.
)
as
/*
Returns all the FK column names and the parent table name
for the given source table.
*/
set nocount on;


with GUIDCOLS (COLUMN_NAME,PARENT_TABLENAME) as
(
    select COLUMN_NAME,dbo.UFN_SCHEMA_GETPARENTTABLENAME(@SOURCETABLENAME,COLUMN_NAME) as PARENT_TABLENAME
    from INFORMATION_SCHEMA.COLUMNS 
    where 
        (TABLE_SCHEMA = 'dbo') 
        and (TABLE_NAME = @SOURCETABLENAME)
        and DATA_TYPE='uniqueidentifier' 
        and COLUMN_NAME not in ('ID', 'TS', 'TSLONG')
)

select COLUMN_NAME,PARENT_TABLENAME from GUIDCOLS
where PARENT_TABLENAME is not null order by COLUMN_NAME;

return 0;