Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

ROUTINE_COLUMNS (Transact-SQL)

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 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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.