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. |
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 SQL-92 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. |
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
Reference
System Views (Transact-SQL)
Information Schema Views (Transact-SQL)
sys.columns (Transact-SQL)
sys.objects (Transact-SQL)
Other Resources
Querying the SQL Server System Catalog