ROUTINE_COLUMNS


Columns

Column Type Size Nulls Auto Default Children Parents Comments
TABLE_CATALOG nvarchar 256 √ null
TABLE_SCHEMA nvarchar 256 √ null
TABLE_NAME sysname 256 null
COLUMN_NAME sysname 256 √ null
ORDINAL_POSITION int 4 null
COLUMN_DEFAULT nvarchar 8000 √ null
IS_NULLABLE varchar 3 √ null
DATA_TYPE nvarchar 256 √ null
CHARACTER_MAXIMUM_LENGTH int 4 √ null
CHARACTER_OCTET_LENGTH int 4 √ null
NUMERIC_PRECISION tinyint 1 √ null
NUMERIC_PRECISION_RADIX smallint 2 √ null
NUMERIC_SCALE int 4 √ null
DATETIME_PRECISION smallint 2 √ null
CHARACTER_SET_CATALOG sysname 256 √ null
CHARACTER_SET_SCHEMA sysname 256 √ null
CHARACTER_SET_NAME sysname 256 √ null
COLLATION_CATALOG sysname 256 √ null
COLLATION_SCHEMA sysname 256 √ null
COLLATION_NAME sysname 256 √ null
DOMAIN_CATALOG sysname 256 √ null
DOMAIN_SCHEMA sysname 256 √ null
DOMAIN_NAME sysname 256 √ null

Relationships