Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

ROUTINE_COLUMNS (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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.

Applies to: SQL Server (SQL Server 2008 through current version), Azure SQL Database, Azure SQL Data Warehouse Public Preview.

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 note 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 ISO integer 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 note 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.

Community Additions

ADD
Show:
© 2015 Microsoft