Thanks in advance
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/
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...