Export (0) Print
Expand All

ROUTINE_COLUMNS

SQL Server 2000

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.

Column name Data type Description
TABLE_CATALOG nvarchar(128) Catalog or database name of the table-valued function.
TABLE_SCHEMA nvarchar(128) Owner of the table-valued function.
TABLE_NAME nvarchar(128) Name of the table-valued function.
COLUMN_NAME nvarchar(128) Column name.
ORDINAL_POSITION smallint Column identification number.
COLUMN_DEFAULT nvarchar(4000) Default value of the column.
IS_NULLABLE varchar(3) If this column allows NULL, returns YES. Otherwise, returns NO.
DATA_TYPE nvarchar(128) System-supplied data type.
CHARACTER_MAXIMUM_LENGTH smallint Maximum length, in characters, for binary data, character data, or text and image data. Otherwise, returns NULL. For more information, see Data Types.
CHARACTER_OCTET_LENGTH smallint Maximum length, in bytes, for binary data, character data, or text and image data. Otherwise, returns NULL.
NUMERIC_PRECISION tinyint Precision of approximate numeric data, exact numeric data, integer data, or monetary data. Otherwise, returns NULL.
NUMERIC_PRECISION_RADIX smallint Precision radix of approximate numeric data, exact numeric data, integer data, or monetary data. Otherwise, returns NULL.
NUMERIC_SCALE tinyint Scale of approximate numeric data, exact numeric data, integer data, or monetary data. Otherwise, returns NULL.
DATETIME_PRECISION smallint Subtype code for datetime and SQL-92 integer data types. For other data types, returns NULL.
CHARACTER_SET_CATALOG varchar(6) Returns master, indicating the database in which the character set is located, if the column is character data or text data type. Otherwise, returns NULL.
CHARACTER_SET_SCHEMA varchar(3) Returns DBO, indicating the owner name of the character set, if the column is character data or text data type. Otherwise, returns NULL.
CHARACTER_SET_NAME nvarchar(128) Returns the unique name for the character set if this column is character data or text data type. Otherwise, returns NULL.
COLLATION_CATALOG varchar(6) Returns master, indicating the database in which the sort order is defined, if the column is character data or text data type. Otherwise, returns NULL.
COLLATION_SCHEMA varchar(3) Returns DBO, indicating the owner of the sort order for character data or text data type. Otherwise, returns NULL.
COLLATION_NAME nvarchar(128) Returns the unique name for the sort order if the column is character data or text data type. Otherwise, returns NULL.
DOMAIN_CATALOG nvarchar(128) If the column is a user-defined data type, this column is the database name in which the user-defined data type was created. Otherwise, returns NULL.
DOMAIN_SCHEMA nvarchar(128) If the column is a user-defined data type, this column is the creator of the user-defined data type. Otherwise, returns NULL.
DOMAIN_NAME nvarchar(128) If the column is a user-defined data type, this column is the name of the user-defined data type. Otherwise, returns NULL.

See Also

syscolumns

sysobjects

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft