ROUTINES


Columns

Column Type Size Nulls Auto Default Children Parents Comments
SPECIFIC_CATALOG nvarchar 256 √ null
SPECIFIC_SCHEMA nvarchar 256 √ null
SPECIFIC_NAME sysname 256 null
ROUTINE_CATALOG nvarchar 256 √ null
ROUTINE_SCHEMA nvarchar 256 √ null
ROUTINE_NAME sysname 256 null
ROUTINE_TYPE nvarchar 40 √ null
MODULE_CATALOG sysname 256 √ null
MODULE_SCHEMA sysname 256 √ null
MODULE_NAME sysname 256 √ null
UDT_CATALOG sysname 256 √ null
UDT_SCHEMA sysname 256 √ null
UDT_NAME sysname 256 √ null
DATA_TYPE sysname 256 √ null
CHARACTER_MAXIMUM_LENGTH int 4 √ null
CHARACTER_OCTET_LENGTH int 4 √ null
COLLATION_CATALOG sysname 256 √ null
COLLATION_SCHEMA sysname 256 √ null
COLLATION_NAME sysname 256 √ null
CHARACTER_SET_CATALOG sysname 256 √ null
CHARACTER_SET_SCHEMA sysname 256 √ null
CHARACTER_SET_NAME sysname 256 √ null
NUMERIC_PRECISION tinyint 1 √ null
NUMERIC_PRECISION_RADIX smallint 2 √ null
NUMERIC_SCALE int 4 √ null
DATETIME_PRECISION smallint 2 √ null
INTERVAL_TYPE nvarchar 60 √ null
INTERVAL_PRECISION smallint 2 √ null
TYPE_UDT_CATALOG sysname 256 √ null
TYPE_UDT_SCHEMA sysname 256 √ null
TYPE_UDT_NAME sysname 256 √ null
SCOPE_CATALOG sysname 256 √ null
SCOPE_SCHEMA sysname 256 √ null
SCOPE_NAME sysname 256 √ null
MAXIMUM_CARDINALITY bigint 8 √ null
DTD_IDENTIFIER sysname 256 √ null
ROUTINE_BODY nvarchar 60 √ null
ROUTINE_DEFINITION nvarchar 8000 √ null
EXTERNAL_NAME sysname 256 √ null
EXTERNAL_LANGUAGE nvarchar 60 √ null
PARAMETER_STYLE nvarchar 60 √ null
IS_DETERMINISTIC nvarchar 20 √ null
SQL_DATA_ACCESS nvarchar 60 √ null
IS_NULL_CALL nvarchar 20 √ null
SQL_PATH sysname 256 √ null
SCHEMA_LEVEL_ROUTINE nvarchar 20 √ null
MAX_DYNAMIC_RESULT_SETS smallint 2 √ null
IS_USER_DEFINED_CAST nvarchar 20 √ null
IS_IMPLICITLY_INVOCABLE nvarchar 20 √ null
CREATED datetime 16,3 null
LAST_ALTERED datetime 16,3 null

Relationships

Close relationships within degrees of separation