USP_SCHEMAINFO_GETROUTINECOLUMNINFO

        create procedure dbo.USP_SCHEMAINFO_GETROUTINECOLUMNINFO (@FUNCTIONNAME nvarchar(128), @TABLESCHEMA nvarchar(128) = 'dbo')
        as
            select COLUMN_NAME, 
                DATA_TYPE, 
                CHARACTER_MAXIMUM_LENGTH, 
                DOMAIN_NAME
            from INFORMATION_SCHEMA.ROUTINE_COLUMNS
            where TABLE_SCHEMA = @TABLESCHEMA
            and TABLE_NAME = @FUNCTIONNAME
            order by ORDINAL_POSITION