ROUTINE_COLUMNS (Transact-SQL)
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
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: Don't use INFORMATION_SCHEMA views to determine the schema of an object. INFORMATION_SCHEMA views only represent a subset of the metadata of an object. The only reliable way to find the schema of an 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: Don't use INFORMATION_SCHEMA views to determine the schema of an object. INFORMATION_SCHEMA views only represent a subset of the metadata of an object. The only reliable way to find the schema of an 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)