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. .gif "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 an object is to query the sys.objects catalog view or OBJECT_SCHEMA_NAME function.
|
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
Do not use INFORMATION_SCHEMA views to determine the schema of an object. The only reliable way to find the schema of an object is to query the sys.objects catalog view or OBJECT_SCHEMA_NAME function.
|
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. |
Examples
The following example returns information about each column returned by the table-valued functions in the database.
USE AdventureWorks;
GO
SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, ORDINAL_POSITION, IS_NULLABLE, DATA_TYPE
FROM INFORMATION_SCHEMA.ROUTINE_COLUMNS;