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

1     create table spt_sybdrv(-- 27 Rows, Data: 2 KB, Index: 2 KB
2         type_name varchar(20) not null,
3         data_type int not null,
4         tds_type int null
5     )
6     
7     
8     alter table spt_sybdrv add primary key clustered (type_name) -- 2 KB refcount: 2
9     
10    Grant Select on spt_sybdrv to public
11    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength

Estimated Index Usage
spt_sybdrv.spt_sybdrv_type_n_2866210331 unique clustered(type_name)2

ALIASES USED for sybsystemprocs..spt_sybdrv
NO_ALIASm
17

SCHEMA

COLUMN USAGE
type_namesp_oledb_columns  sp_oledb_datatype_info  sp_oledb_getprocedurecolumns 
data_typesp_oledb_columns  sp_oledb_datatype_info  sp_oledb_getprocedurecolumns 
tds_typesp_oledb_datatype_info 

QUERIES
Joined With Links

DATA PROPAGATION detailed
ColumnWritten To
data_typesp_oledb_columns_rset_002.TYPE_NAME 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.DATA_TYPE sp_oledb_getprocedurecolumns_rset_002.DATA_TYPE

DEPENDENCIES
READERS AND WRITERS
read by proc sybsystemprocs..sp_oledb_getprocedurecolumns  
read by proc sybsystemprocs..sp_oledb_datatype_info  
read by proc sybsystemprocs..sp_oledb_columns