How to retrieve metadata for return values of an sql server inline table-valued function?

Question

It's not in INFORMATION_SCHEMA.COLUMNS, so where is it?

This is a schemabound inline table valued function, so it doesn't have the issues which a stored procedure might have in being able to vary its output schema(s) based on parameters.

Answer 1

SELECT *
FROM sys.columns
WHERE [object_id] = OBJECT_ID('udf Name Here')

Answer 2

Check out the ROUTINE_COLUMNS view if you're using SQL2005 or SQL2008