Retieving Column Names of Table Valued UDF

[Gridlock]

I can retrieve column names, data types, etc. from Tables or Views from
information.schema.columns, but columns of Table Valued UDF's are not listed
there. How do I retrieve column information for UDF's?

Thanks in advance

[SQL Menace]

Take a look at INFORMATION_SCHEMA.ROUTINE_COLUMNS

ROUTINE_COLUMNS
Contains one row for each column returned by the table-valued functions
accessible to the current user in the current database.

The INFORMATION_SCHEMA.ROUTINE_COLUMNS view is based on the sysobjects
and syscolumns system tables.

To retrieve information from this view, specify the fully qualified
name of INFORMATION_SCHEMA view_name.

Denis the SQL Menace
http://sqlservercode.blogspot.com/

[Tibor Karaszi]

What version of SQL Server?

2000: syscolumns
2005: sys.columns

Reason for them not being in information schema views is probably that there are no such things as
user defined function in ANSI SQL.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/

"Gridlock" <Grid...@discussions.microsoft.com> wrote in message
news:2E0EF9E2-4557-4D45...@microsoft.com...

[Gridlock]

currently 2000, but need to worry about 2005 at some point

[Gridlock]

THANK YOU!! That was it!