routine-columns-transact-sql.md

title	ROUTINE_COLUMNS (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/15/2017
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	ROUTINE_COLUMNS_TSQL ROUTINE_COLUMNS
dev_langs	TSQL
helpviewer_keywords	ROUTINE_COLUMNS view INFORMATION_SCHEMA.ROUTINE_COLUMNS view
ms.assetid	91dbc61b-e4c0-4826-976c-b2fce88b7793
caps.latest.revision	37
author	BYHAM
ms.author	rickbyh
manager	jhubbard

ROUTINE_COLUMNS (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-asdb-xxxx-xxx_md]

Returns one row for each column returned by the table-valued functions that can be accessed by the current user in the current database.

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)	Name of the schema that contains the table-valued function. ** Important ** Do not use INFORMATION_SCHEMA views to determine the schema of an object. The only reliable way to find the schema of a object is to query the sys.objects catalog view.
TABLE_NAME	nvarchar(128)	Name of the table-valued function.
COLUMN_NAME	nvarchar(128)	Column name.
ORDINAL_POSITION	int	Column identification number.
COLUMN_DEFAULT	nvarchar(4000)	Default value of the column.
IS_NULLABLE	varchar(3)	If this column allows for NULL, returns YES. Otherwise, returns NO.
DATA_TYPE	nvarchar(128)	System-supplied data type.
CHARACTER_MAXIMUM_LENGTH	int	Maximum length, in characters, for binary data, character data, or text and image data. -1 for xml and large-value type data. Otherwise, returns NULL. For more information, see Data Types (Transact-SQL).
CHARACTER_OCTET_LENGTH	int	Maximum length, in bytes, for binary data, character data, or text and image data. -1 for xml and large-value type 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 ISOinteger data types. For other data types, returns NULL.
CHARACTER_SET_CATALOG	varchar(6)	Returns master. This indicates 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)	Always 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)	Always returns NULL.
COLLATION_SCHEMA	varchar(3)	Always 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 an alias 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 name of the schema that contains the user-defined data type. Otherwise, returns NULL. ** Important ** Do not use INFORMATION_SCHEMA views to determine the schema of an object. The only reliable way to find the schema of a object is to query the sys.objects catalog view.
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

System Views (Transact-SQL)
Information Schema Views (Transact-SQL)
sys.columns (Transact-SQL)
sys.objects (Transact-SQL)