DatabaseTableApplicationCreatedLinks
sybsystemprocsspt_datatype_info  14 déc. 14Joins Schema ColumnUsage Queries Writes Propagation Dependencies

1     create table spt_datatype_info(-- 35 Rows, Data: 4 KB, Index: 0 B
2         ss_dtype tinyint not null,
3         type_name varchar(32) not null,
4         data_type smallint not null,
5         data_precision int null,
6         numeric_scale smallint null,
7         numeric_radix smallint null,
8         length int null,
9         literal_prefix varchar(32) null,
10        literal_suffix varchar(32) null,
11        create_params varchar(32) null,
12        nullable smallint not null,
13        case_sensitive smallint not null,
14        searchable smallint not null,
15        unsigned_attribute smallint null,
16        money smallint not null,
17        auto_increment smallint null,
18        local_type_name varchar(128) not null,
19        aux int null,
20        maximum_scale smallint null,
21        minimum_scale smallint null,
22        sql_data_type smallint null,
23        sql_datetime_sub smallint null,
24        num_prec_radix smallint null,
25        interval_precision smallint null
26    )
27    
28    Grant Select on spt_datatype_info to public
29    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[ss_dtype]sybsystemprocs..systypes[type]19 Simple Join
[ss_dtype]sybsystemprocs..syscolumns[type]12 Simple Join

ALIASES USED for sybsystemprocs..spt_datatype_info
NO_ALIASd
343

SCHEMA

COLUMN USAGE
ss_dtypesp_columns  sp_datatype_info  sp_drv_typeinfo  sp_localtypename  sp_odbc_columns  sp_odbc_datatype_info  sp_odbc_getprocedurecolumns  sp_odbc_getversioncolumns  sp_oledb_columns  sp_oledb_datatype_info  sp_oledb_getprocedurecolumns  sp_special_columns  sp_sproc_columns 
type_namesp_columns  sp_odbc_columns  sp_odbc_getprocedurecolumns  sp_odbc_getversioncolumns  sp_oledb_columns  sp_oledb_getprocedurecolumns  sp_special_columns  sp_sproc_columns 
data_typesp_columns  sp_datatype_info  sp_odbc_columns  sp_odbc_datatype_info  sp_odbc_getprocedurecolumns  sp_odbc_getversioncolumns  sp_special_columns  sp_sproc_columns 
data_precisionsp_columns  sp_datatype_info  sp_odbc_columns  sp_odbc_datatype_info  sp_odbc_getprocedurecolumns  sp_odbc_getversioncolumns  sp_oledb_columns  sp_oledb_datatype_info  sp_oledb_getprocedurecolumns  sp_special_columns  sp_sproc_columns 
numeric_scalesp_columns  sp_odbc_columns  sp_odbc_getprocedurecolumns  sp_odbc_getversioncolumns  sp_oledb_columns  sp_oledb_getprocedurecolumns  sp_special_columns  sp_sproc_columns 
numeric_radixsp_columns  sp_odbc_columns  sp_odbc_getprocedurecolumns  sp_oledb_columns  sp_oledb_getprocedurecolumns  sp_sproc_columns 
lengthsp_columns  sp_odbc_getprocedurecolumns  sp_odbc_getversioncolumns  sp_oledb_getprocedurecolumns  sp_special_columns  sp_sproc_columns 
literal_prefixsp_datatype_info  sp_drv_typeinfo  sp_odbc_datatype_info  sp_oledb_datatype_info 
literal_suffixsp_datatype_info  sp_drv_typeinfo  sp_odbc_datatype_info  sp_oledb_datatype_info 
nullablesp_datatype_info  sp_odbc_datatype_info  sp_oledb_datatype_info 
case_sensitivesp_datatype_info  sp_drv_typeinfo  sp_odbc_datatype_info  sp_oledb_datatype_info 
searchablesp_datatype_info  sp_drv_typeinfo  sp_odbc_datatype_info  sp_oledb_datatype_info 
unsigned_attributesp_datatype_info  sp_drv_typeinfo  sp_odbc_datatype_info  sp_oledb_datatype_info 
moneysp_datatype_info  sp_odbc_datatype_info  sp_oledb_datatype_info 
auto_incrementsp_datatype_info  sp_odbc_datatype_info  sp_oledb_datatype_info 
local_type_namesp_datatype_info  sp_localtypename  sp_odbc_datatype_info  sp_oledb_datatype_info 
auxsp_columns  sp_odbc_columns  sp_odbc_datatype_info  sp_odbc_getprocedurecolumns  sp_odbc_getversioncolumns  sp_oledb_columns  sp_oledb_getprocedurecolumns  sp_special_columns  sp_sproc_columns 
maximum_scalesp_datatype_info  sp_oledb_datatype_info 
minimum_scalesp_datatype_info  sp_odbc_datatype_info  sp_oledb_datatype_info 
sql_data_typesp_columns  sp_datatype_info  sp_odbc_columns  sp_odbc_datatype_info  sp_odbc_getprocedurecolumns  sp_sproc_columns 
sql_datetime_subsp_datatype_info  sp_odbc_datatype_info 
num_prec_radixsp_datatype_info  sp_drv_typeinfo  sp_odbc_datatype_info  sp_oledb_columns 
interval_precisionsp_datatype_info  sp_odbc_datatype_info 

QUERIES
Joined With Links
sybsystemprocs..syscolumns sybsystemprocs..sysobjects sybsystemprocs..sp_sproc_columns:127
sybsystemprocs..sp_sproc_columns:426
sybsystemprocs..sp_odbc_getprocedurecolumns:126
sybsystemprocs..sp_odbc_getprocedurecolumns:464
sybsystemprocs..sp_oledb_getprocedurecolumns:433
sybsystemprocs..sp_oledb_getprocedurecolumns:158
sybsystemprocs..syscolumns sybsystemprocs..sysobjects sybsystemprocs..systypes sybsystemprocs..sp_columns:427
sybsystemprocs..sp_columns:75
sybsystemprocs..sp_columns:186
sybsystemprocs..sp_columns:315
sybsystemprocs..syscolumns sybsystemprocs..sp_special_columns:67
sybsystemprocs..sp_odbc_getversioncolumns:72
sybsystemprocs..spt_datatype_info_ext sybsystemprocs..systypes sybsystemprocs..sp_odbc_datatype_info:57

DATA PROPAGATION detailed
ColumnWritten To
auto_incrementsp_datatype_info_rset_001.auto_increment sp_datatype_info_rset_002.auto_increment sp_odbc_datatype_info_rset_001.AUTO_UNIQUE_VALUE sp_oledb_datatype_info_rset_001.AUTO_UNIQUE_VALUE sp_oledb_datatype_info_rset_002.AUTO_UNIQUE_VALUE sp_oledb_datatype_info_rset_003.AUTO_UNIQUE_VALUE
auxsp_columns_rset_001.data_type °.type_name °.precision °.length °.scale °.sql_data_type °.char_octet_length sp_columns_rset_002.data_type °.type_name °.precision
°.length °.scale °.sql_data_type °.char_octet_length sp_odbc_datatype_info_rset_001.SQL_DATA_TYPE sp_odbc_getprocedurecolumns_rset_001.DATA_TYPE °.TYPE_NAME °.COLUMN_SIZE °.BUFFER_LENGTH °.DECIMAL_DIGITS
°.SQL_DATA_TYPE °.CHAR_OCTET_LENGTH sp_odbc_getprocedurecolumns_rset_002.DATA_TYPE °.TYPE_NAME °.COLUMN_SIZE °.BUFFER_LENGTH °.DECIMAL_DIGITS °.SQL_DATA_TYPE °.CHAR_OCTET_LENGTH sp_odbc_getversioncolumns_rset_001.DATA_TYPE
°.TYPE_NAME °.COLUMN_SIZE °.BUFFER_LENGTH °.DECIMAL_DIGITS sp_odbc_getversioncolumns_rset_002.DATA_TYPE °.TYPE_NAME °.COLUMN_SIZE °.BUFFER_LENGTH °.DECIMAL_DIGITS sp_odbc_getversioncolumns_rset_003.DATA_TYPE
°.COLUMN_SIZE °.BUFFER_LENGTH °.DECIMAL_DIGITS sp_oledb_columns_rset_001.DATA_TYPE °.NUMERIC_PRECISION °.CHARACTER_SET_CATALOG sp_oledb_columns_rset_002.NUMERIC_PRECISION °.NUMERIC_SCALE sp_oledb_getprocedurecolumns_rset_001.CHARACTER_MAXIMUM_LENGTH °.CHARACTER_OCTET_LENGTH
°.NUMERIC_PRECISION_RADIX °.DESCRIPTION °.TYPE_NAME sp_oledb_getprocedurecolumns_rset_002.CHARACTER_MAXIMUM_LENGTH °.CHARACTER_OCTET_LENGTH °.DESCRIPTION °.LOCAL_TYPE_NAME sp_special_columns_rset_001.data_type °.type_name °.precision
°.length °.scale sp_special_columns_rset_002.data_type °.type_name °.precision °.length °.scale sp_special_columns_rset_003.data_type °.precision °.length
°.scale sp_sproc_columns_rset_001.data_type °.type_name °.precision °.length °.scale °.sql_data_type °.char_octet_length sp_sproc_columns_rset_002.data_type °.type_name
°.precision °.length °.scale °.sql_data_type °.char_octet_length
case_sensitivesp_datatype_info_rset_001.case_sensitive sp_datatype_info_rset_002.case_sensitive sp_drv_typeinfo_rset_001.case_sensitive sp_drv_typeinfo_rset_002.case_sensitive sp_odbc_datatype_info_rset_001.CASE_SENSITIVE sp_oledb_datatype_info_rset_001.CASE_SENSITIVE sp_oledb_datatype_info_rset_002.CASE_SENSITIVE sp_oledb_datatype_info_rset_003.CASE_SENSITIVE
data_precisionsp_columns_rset_001.precision °.char_octet_length sp_columns_rset_002.precision °.char_octet_length sp_datatype_info_rset_001.precison sp_datatype_info_rset_002.precison sp_odbc_datatype_info_rset_001.COLUMN_SIZE sp_odbc_getprocedurecolumns_rset_001.COLUMN_SIZE °.CHAR_OCTET_LENGTH sp_odbc_getprocedurecolumns_rset_002.COLUMN_SIZE
°.CHAR_OCTET_LENGTH sp_odbc_getversioncolumns_rset_001.COLUMN_SIZE sp_odbc_getversioncolumns_rset_002.COLUMN_SIZE sp_odbc_getversioncolumns_rset_003.COLUMN_SIZE sp_oledb_columns_rset_001.NUMERIC_PRECISION sp_oledb_columns_rset_002.NUMERIC_PRECISION sp_oledb_datatype_info_rset_001.COLUMN_SIZE sp_oledb_datatype_info_rset_002.COLUMN_SIZE sp_oledb_datatype_info_rset_003.COLUMN_SIZE sp_oledb_getprocedurecolumns_rset_001.CHARACTER_MAXIMUM_LENGTH
°.CHARACTER_OCTET_LENGTH °.NUMERIC_PRECISION sp_oledb_getprocedurecolumns_rset_002.CHARACTER_MAXIMUM_LENGTH °.CHARACTER_OCTET_LENGTH °.NUMERIC_PRECISION sp_special_columns_rset_001.precision sp_special_columns_rset_002.precision sp_special_columns_rset_003.precision sp_sproc_columns_rset_001.precision °.char_octet_length
sp_sproc_columns_rset_002.precision °.char_octet_length
data_typesp_columns_rset_001.data_type °.sql_data_type sp_columns_rset_002.data_type °.sql_data_type sp_datatype_info_rset_001.data_type sp_datatype_info_rset_002.data_type sp_odbc_datatype_info_rset_001.DATA_TYPE °.SQL_DATA_TYPE sp_odbc_getprocedurecolumns_rset_001.DATA_TYPE °.SQL_DATA_TYPE
sp_odbc_getprocedurecolumns_rset_002.DATA_TYPE °.SQL_DATA_TYPE sp_odbc_getversioncolumns_rset_001.DATA_TYPE sp_odbc_getversioncolumns_rset_002.DATA_TYPE sp_odbc_getversioncolumns_rset_003.DATA_TYPE sp_special_columns_rset_001.data_type sp_special_columns_rset_002.data_type sp_special_columns_rset_003.data_type sp_sproc_columns_rset_001.data_type °.sql_data_type
sp_sproc_columns_rset_002.data_type °.sql_data_type
interval_precisionsp_datatype_info_rset_001.sql_datetime_sub sp_odbc_datatype_info_rset_001.INTERVAL_PRECISION
lengthsp_columns_rset_001.length sp_columns_rset_002.length sp_odbc_getprocedurecolumns_rset_001.BUFFER_LENGTH sp_odbc_getprocedurecolumns_rset_002.BUFFER_LENGTH sp_odbc_getversioncolumns_rset_001.BUFFER_LENGTH sp_odbc_getversioncolumns_rset_002.BUFFER_LENGTH sp_odbc_getversioncolumns_rset_003.BUFFER_LENGTH sp_special_columns_rset_001.length sp_special_columns_rset_002.length sp_special_columns_rset_003.length
sp_sproc_columns_rset_001.length sp_sproc_columns_rset_002.length
literal_prefixsp_datatype_info_rset_001.literal_prefix sp_datatype_info_rset_002.literal_prefix sp_drv_typeinfo_rset_001.literal_prefix sp_drv_typeinfo_rset_002.literal_prefix sp_odbc_datatype_info_rset_001.LITERAL_PREFIX sp_oledb_datatype_info_rset_001.LITERAL_PREFIX sp_oledb_datatype_info_rset_002.LITERAL_PREFIX sp_oledb_datatype_info_rset_003.LITERAL_PREFIX
literal_suffixsp_datatype_info_rset_001.literal_suffix sp_datatype_info_rset_002.literal_suffix sp_drv_typeinfo_rset_001.literal_suffix sp_drv_typeinfo_rset_002.literal_suffix sp_odbc_datatype_info_rset_001.LITERAL_SUFFIX sp_oledb_datatype_info_rset_001.LITERAL_SUFFIX sp_oledb_datatype_info_rset_002.LITERAL_SUFFIX sp_oledb_datatype_info_rset_003.LITERAL_SUFFIX
local_type_namesp_datatype_info_rset_001.local_type_name sp_datatype_info_rset_002.local_type_name sp_localtypename_rset_001.local_type_name sp_odbc_datatype_info_rset_001.LOCAL_TYPE_NAME sp_oledb_datatype_info_rset_001.LOCAL_TYPE_NAME sp_oledb_datatype_info_rset_002.LOCAL_TYPE_NAME sp_oledb_datatype_info_rset_003.LOCAL_TYPE_NAME
maximum_scalesp_datatype_info_rset_002.sql_datetime_sub sp_oledb_datatype_info_rset_001.MAXIMUM_SCALE sp_oledb_datatype_info_rset_002.MAXIMUM_SCALE sp_oledb_datatype_info_rset_003.MAXIMUM_SCALE
minimum_scalesp_datatype_info_rset_002.sql_data_type sp_odbc_datatype_info_rset_001.MINIMUM_SCALE °.MAXIMUM_SCALE sp_oledb_datatype_info_rset_001.MINIMUM_SCALE sp_oledb_datatype_info_rset_002.MINIMUM_SCALE sp_oledb_datatype_info_rset_003.MINIMUM_SCALE
moneysp_datatype_info_rset_001.money sp_datatype_info_rset_002.money sp_odbc_datatype_info_rset_001.FIXED_PREC_SCALE sp_oledb_datatype_info_rset_001.FIXED_PREC_SCALE sp_oledb_datatype_info_rset_002.FIXED_PREC_SCALE sp_oledb_datatype_info_rset_003.FIXED_PREC_SCALE
nullablesp_datatype_info_rset_001.nullable sp_datatype_info_rset_002.nullable sp_odbc_datatype_info_rset_001.NULLABLE sp_oledb_datatype_info_rset_001.IS_NULLABLE sp_oledb_datatype_info_rset_002.IS_NULLABLE sp_oledb_datatype_info_rset_003.IS_NULLABLE
num_prec_radixsp_datatype_info_rset_001.sql_data_type sp_drv_typeinfo_rset_001.num_prec_radix sp_drv_typeinfo_rset_002.num_prec_radix sp_odbc_datatype_info_rset_001.NUM_PREC_RADIX sp_oledb_columns_rset_001.NUMERIC_SCALE
numeric_radixsp_columns_rset_001.radix sp_columns_rset_002.radix sp_odbc_getprocedurecolumns_rset_001.NUM_PREC_RADIX sp_odbc_getprocedurecolumns_rset_002.NUM_PREC_RADIX sp_oledb_columns_rset_001.NUMERIC_SCALE sp_oledb_getprocedurecolumns_rset_002.NUMERIC_SCALE sp_sproc_columns_rset_001.radix sp_sproc_columns_rset_002.radix
numeric_scalesp_columns_rset_001.scale sp_columns_rset_002.scale sp_odbc_getprocedurecolumns_rset_001.DECIMAL_DIGITS sp_odbc_getprocedurecolumns_rset_002.DECIMAL_DIGITS sp_odbc_getversioncolumns_rset_001.DECIMAL_DIGITS sp_odbc_getversioncolumns_rset_002.DECIMAL_DIGITS sp_odbc_getversioncolumns_rset_003.DECIMAL_DIGITS sp_oledb_columns_rset_001.CHARACTER_SET_CATALOG sp_oledb_columns_rset_002.NUMERIC_SCALE sp_oledb_getprocedurecolumns_rset_001.NUMERIC_PRECISION_RADIX
sp_oledb_getprocedurecolumns_rset_002.DESCRIPTION sp_special_columns_rset_001.scale sp_special_columns_rset_002.scale sp_special_columns_rset_003.scale sp_sproc_columns_rset_001.scale sp_sproc_columns_rset_002.scale
searchablesp_datatype_info_rset_001.searchable sp_datatype_info_rset_002.searchable sp_drv_typeinfo_rset_001.searchable sp_drv_typeinfo_rset_002.searchable sp_odbc_datatype_info_rset_001.SEARCHABLE sp_oledb_datatype_info_rset_001.SEARCHABLE sp_oledb_datatype_info_rset_002.SEARCHABLE sp_oledb_datatype_info_rset_003.SEARCHABLE
sql_data_typesp_columns_rset_001.sql_data_type sp_columns_rset_002.sql_data_type sp_datatype_info_rset_001.minimum_scale sp_datatype_info_rset_002.num_prec_radix sp_odbc_datatype_info_rset_001.SQL_DATA_TYPE sp_odbc_getprocedurecolumns_rset_001.SQL_DATA_TYPE sp_odbc_getprocedurecolumns_rset_002.SQL_DATA_TYPE sp_sproc_columns_rset_001.sql_data_type sp_sproc_columns_rset_002.sql_data_type
sql_datetime_subsp_datatype_info_rset_001.maximum_scale sp_datatype_info_rset_002.interval_precision sp_odbc_datatype_info_rset_001.SQL_DATETIME_SUB
ss_dtypesp_columns_rset_001.data_type °.type_name °.precision °.length °.scale °.sql_data_type °.char_octet_length sp_columns_rset_002.data_type °.type_name °.precision
°.length °.scale °.sql_data_type °.char_octet_length sp_odbc_getprocedurecolumns_rset_001.DATA_TYPE °.TYPE_NAME °.COLUMN_SIZE °.BUFFER_LENGTH °.DECIMAL_DIGITS °.SQL_DATA_TYPE
°.CHAR_OCTET_LENGTH sp_odbc_getprocedurecolumns_rset_002.DATA_TYPE °.TYPE_NAME °.COLUMN_SIZE °.BUFFER_LENGTH °.DECIMAL_DIGITS °.SQL_DATA_TYPE °.CHAR_OCTET_LENGTH sp_odbc_getversioncolumns_rset_001.DATA_TYPE °.TYPE_NAME
°.COLUMN_SIZE °.BUFFER_LENGTH °.DECIMAL_DIGITS sp_odbc_getversioncolumns_rset_002.DATA_TYPE °.TYPE_NAME °.COLUMN_SIZE °.BUFFER_LENGTH °.DECIMAL_DIGITS sp_odbc_getversioncolumns_rset_003.DATA_TYPE °.COLUMN_SIZE
°.BUFFER_LENGTH °.DECIMAL_DIGITS sp_oledb_columns_rset_001.DATA_TYPE °.NUMERIC_PRECISION °.CHARACTER_SET_CATALOG sp_oledb_columns_rset_002.NUMERIC_PRECISION °.NUMERIC_SCALE sp_oledb_datatype_info_rset_001.DATA_TYPE sp_oledb_datatype_info_rset_002.DATA_TYPE sp_oledb_datatype_info_rset_003.DATA_TYPE
sp_oledb_getprocedurecolumns_rset_001.CHARACTER_MAXIMUM_LENGTH °.CHARACTER_OCTET_LENGTH °.NUMERIC_PRECISION_RADIX °.DESCRIPTION °.TYPE_NAME sp_oledb_getprocedurecolumns_rset_002.CHARACTER_MAXIMUM_LENGTH °.CHARACTER_OCTET_LENGTH °.DESCRIPTION °.LOCAL_TYPE_NAME sp_special_columns_rset_001.data_type
°.type_name °.precision °.length °.scale sp_special_columns_rset_002.data_type °.type_name °.precision °.length °.scale sp_special_columns_rset_003.data_type
°.precision °.length °.scale sp_sproc_columns_rset_001.data_type °.type_name °.precision °.length °.scale °.sql_data_type °.char_octet_length
sp_sproc_columns_rset_002.data_type °.type_name °.precision °.length °.scale °.sql_data_type °.char_octet_length
type_namesp_columns_rset_001.type_name sp_columns_rset_002.type_name sp_odbc_getprocedurecolumns_rset_001.TYPE_NAME sp_odbc_getprocedurecolumns_rset_002.TYPE_NAME sp_odbc_getversioncolumns_rset_001.TYPE_NAME sp_odbc_getversioncolumns_rset_002.TYPE_NAME sp_oledb_columns_rset_001.DATA_TYPE sp_oledb_getprocedurecolumns_rset_001.DESCRIPTION °.TYPE_NAME sp_oledb_getprocedurecolumns_rset_002.LOCAL_TYPE_NAME
sp_special_columns_rset_001.type_name sp_special_columns_rset_002.type_name sp_sproc_columns_rset_001.type_name sp_sproc_columns_rset_002.type_name
unsigned_attributesp_datatype_info_rset_001.unsigned_attribute sp_datatype_info_rset_002.unsigned_attribute sp_drv_typeinfo_rset_001.unsigned_attribute sp_drv_typeinfo_rset_002.unsigned_attribute sp_odbc_datatype_info_rset_001.UNSIGNED_ATTRIBUTE sp_oledb_datatype_info_rset_001.UNSIGNED_ATTRIBUTE sp_oledb_datatype_info_rset_002.UNSIGNED_ATTRIBUTE sp_oledb_datatype_info_rset_003.UNSIGNED_ATTRIBUTE

DEPENDENCIES
READERS AND WRITERS
read by proc sybsystemprocs..sp_sproc_columns  
read by proc sybsystemprocs..sp_odbc_datatype_info  
read by proc sybsystemprocs..sp_datatype_info  
read by proc sybsystemprocs..sp_odbc_columns  
read by proc sybsystemprocs..sp_special_columns  
read by proc sybsystemprocs..sp_localtypename  
read by proc sybsystemprocs..sp_odbc_getprocedurecolumns  
read by proc sybsystemprocs..sp_oledb_columns  
read by proc sybsystemprocs..sp_drv_typeinfo  
read by proc sybsystemprocs..sp_oledb_datatype_info  
read by proc sybsystemprocs..sp_oledb_getprocedurecolumns  
read by proc sybsystemprocs..sp_odbc_getversioncolumns  
read by proc sybsystemprocs..sp_columns