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

1     create table syscolumns(-- 2.1 KRows, Data: 198 KB, Index: 272 KB
2         id int not null,
3         number smallint not null,
4         colid smallint not null,
5         status tinyint not null,
6         type tinyint not null,
7         length int not null,
8         offset smallint not null,
9         usertype smallint not null,
10        cdefault int not null,
11        domain int not null,
12        name longsysname(255) not null,
13        printfmt varchar(255) null,
14        prec tinyint null,
15        scale tinyint null,
16        remote_type int null,
17        remote_name varchar(255) null,
18        xstatus int null,
19        xtype int null,
20        xdbid int null,
21        accessrule int null,
22        status2 int null,
23        status3 smallint not null,
24        computedcol int null,
25        encrtype int null,
26        encrlen int null,
27        encrkeyid int null,
28        encrkeydb sysname null,
29        encrdate datetime null,
30        lobcomp_lvl tinyint null,
31        inrowlen smallint null
32    )
33    
34    
35    create unique clustered index csyscolumns on syscolumns(-- 74 KB refcount: 302
36        id, number, colid
37    )
38    
39    alter table syscolumns lock datarows
40    
41    Grant Select on syscolumns to public
42    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[id]sybsystemprocs..sysobjects[id]64 FK
[usertype]sybsystemprocs..systypes[usertype]40 FK
[type]master..spt_values[low]36 Simple Join
[id]sybsystemprocs..sysindexes[id]13 Simple Join
[type]sybsystemprocs..spt_datatype_info[ss_dtype]12 Simple Join
[status2]master..spt_values[number]5 Simple Join
[type]sybsystemprocs..spt_jdbc_datatype_info[ss_dtype]4 Simple Join
[name]sybsystemprocs..syscolumns[name]4 Simple Join
[usertype]sybsystemprocs..syscolumns[usertype]4 Simple Join
[xtype]sybsystemprocs..sysxtypes[xtid]3 FK
[name]master..spt_values[name]3 Simple Join
[type]sybsystemprocs..spt_jdatatype_info[ss_dtype]3 Simple Join
[colid]sybsystemprocs..syscolumns[name]3 Simple Join
[name]sybsystemprocs..syscolumns[colid]3 Simple Join
[id, colid]sybsystemprocs..syspartitionkeys[id, colid]2 Simple Join
[type]sybsystemprocs..systypes[type]2 Simple Join
[cdefault]sybsystemprocs..sysobjects[id]1 FK
[encrkeyid]sybsystemprocs..sysobjects[id]1 FK
[type]master..systypes[type]1 Simple Join
[id, colid]sybsystemprocs..sysattributes[object_info1, object_info2]1 Simple Join
[colid, id]sybsystemprocs..syspartitionkeys[id, colid]1 Simple Join
[cdefault]sybsystemprocs..sysprocedures[id]1 Simple Join

Estimated Index Usage
syscolumns.csyscolumns unique clustered(id, number, colid)302

ALIASES USED for sybsystemprocs..syscolumns
BNO_ALIASabcc1c2colcolumnsisyscolumns
11252020841432123

SCHEMA

COLUMN USAGE
idsp_addgroup  sp_addobjectdef  sp_addsegment  sp_addtype  sp_adduser  sp_aux_computeprivs  sp_aux_encr_verify_downgrade  sp_bindefault  sp_bindrule  sp_changegroup  sp_checknames  sp_checkreswords  sp_chgattribute  sp_column_privileges  sp_columns  sp_commonkey  sp_depends  sp_depends_cols  sp_downgrade  sp_dropextendedproc  sp_droptype  sp_dropuser  sp_drv_bcpmetadata  sp_drv_getcolumnprivileges  sp_encryption  sp_estspace  sp_foreignkey  sp_help  sp_help_params  sp_helpartition  sp_helpcomputedcolumn  sp_helpconfig_process_estimate  sp_helpconstraint  sp_helpextendedproc  sp_helpjava  sp_helpjoins  sp_helpobjectdef  sp_helprotect  sp_ijdbc_aux_computeprivs  sp_ijdbc_columns  sp_ijdbc_getbestrowidentifier  sp_ijdbc_getcolumnprivileges  sp_ijdbc_getindexinfo  sp_ijdbc_getprocedurecolumns  sp_ijdbc_getversioncolumns  sp_index_row_size_est  sp_jdbc_columns  sp_jdbc_computeprivs  sp_jdbc_getbestrowidentifier  sp_jdbc_getfunctioncolumns  sp_jdbc_getindexinfo  sp_jdbc_getversioncolumns  sp_modifystats  sp_odbc_columns  sp_odbc_getindexinfo  sp_odbc_getprocedurecolumns  sp_odbc_getversioncolumns  sp_oledb_columns  sp_oledb_getcolumnprivileges  sp_oledb_getprocedurecolumns  sp_oledb_primarykey  sp_post_xpload  sp_primarykey  sp_rename  sp_setlangalias  sp_setrepcol  sp_setreplicate  sp_setrepproc  sp_setreptable  sp_spaceusage_object_populate  sp_special_columns  sp_sproc_columns  sp_statistics  sp_unbindefault  sp_unbindrule 
numbersp_help_params  sp_ijdbc_getprocedurecolumns  sp_jdbc_getfunctioncolumns  sp_odbc_getprocedurecolumns  sp_oledb_getprocedurecolumns  sp_sproc_columns 
colidsp_aux_computeprivs  sp_aux_encr_verify_downgrade  sp_bindrule  sp_columns  sp_commonkey  sp_depends  sp_depends_cols  sp_drv_bcpmetadata  sp_drv_getcolumnprivileges  sp_foreignkey  sp_help  sp_help_params  sp_helpartition  sp_helpcomputedcolumn  sp_helpconfig_process_estimate  sp_helpjoins  sp_helprotect  sp_ijdbc_aux_computeprivs  sp_ijdbc_columns  sp_ijdbc_getbestrowidentifier  sp_ijdbc_getcolumnprivileges  sp_ijdbc_getindexinfo  sp_ijdbc_getprocedurecolumns  sp_jdbc_columns  sp_jdbc_computeprivs  sp_jdbc_getbestrowidentifier  sp_jdbc_getfunctioncolumns  sp_jdbc_getindexinfo  sp_modifystats  sp_odbc_columns  sp_odbc_getindexinfo  sp_odbc_getprocedurecolumns  sp_odbc_getversioncolumns  sp_oledb_columns  sp_oledb_getcolumnprivileges  sp_oledb_getprocedurecolumns  sp_oledb_primarykey  sp_post_xpload  sp_primarykey  sp_rename  sp_setrepcol  sp_special_columns  sp_sproc_columns  sp_statistics  sp_unbindrule 
statussp_bindrule  sp_chgattribute  sp_columns  sp_depends_cols  sp_drv_bcpmetadata  sp_help  sp_ijdbc_columns  sp_jdbc_columns  sp_odbc_columns  sp_odbc_getversioncolumns  sp_oledb_columns  sp_rename  sp_setrepcol  sp_setreplicate  sp_setreptable  sp_special_columns  sp_sproc_columns  sp_unbindrule 
typesp_aux_encr_verify_downgrade  sp_bindrule  sp_columns  sp_commonkey  sp_depends_cols  sp_drv_bcpmetadata  sp_estspace  sp_foreignkey  sp_helpjoins  sp_ijdbc_columns  sp_ijdbc_getbestrowidentifier  sp_ijdbc_getprocedurecolumns  sp_ijdbc_getversioncolumns  sp_index_row_size_est  sp_jdbc_columns  sp_jdbc_getbestrowidentifier  sp_jdbc_getfunctioncolumns  sp_jdbc_getversioncolumns  sp_odbc_columns  sp_odbc_getprocedurecolumns  sp_odbc_getversioncolumns  sp_oledb_columns  sp_oledb_getprocedurecolumns  sp_post_xpload  sp_setrepcol  sp_setreplicate  sp_setrepproc  sp_setreptable  sp_special_columns  sp_sproc_columns 
lengthsp_addgroup  sp_addobjectdef  sp_addsegment  sp_addtype  sp_adduser  sp_aux_encr_verify_downgrade  sp_bindefault  sp_bindrule  sp_columns  sp_dropextendedproc  sp_drv_bcpmetadata  sp_estspace  sp_help  sp_help_params  sp_helpextendedproc  sp_helpobjectdef  sp_ijdbc_columns  sp_ijdbc_getbestrowidentifier  sp_ijdbc_getprocedurecolumns  sp_ijdbc_getversioncolumns  sp_index_row_size_est  sp_jdbc_columns  sp_jdbc_getbestrowidentifier  sp_jdbc_getfunctioncolumns  sp_jdbc_getversioncolumns  sp_modifystats  sp_odbc_columns  sp_odbc_getprocedurecolumns  sp_odbc_getversioncolumns  sp_oledb_columns  sp_oledb_getprocedurecolumns  sp_rename  sp_setlangalias  sp_special_columns  sp_sproc_columns 
offsetsp_chgattribute  sp_drv_bcpmetadata  sp_estspace  sp_index_row_size_est  sp_spaceusage_object_populate 
usertypesp_bindefault  sp_bindrule  sp_columns  sp_droptype  sp_drv_bcpmetadata  sp_help  sp_help_params  sp_helpjoins  sp_ijdbc_columns  sp_ijdbc_getbestrowidentifier  sp_ijdbc_getversioncolumns  sp_jdbc_columns  sp_jdbc_getbestrowidentifier  sp_jdbc_getfunctioncolumns  sp_jdbc_getversioncolumns  sp_odbc_columns  sp_odbc_getprocedurecolumns  sp_odbc_getversioncolumns  sp_oledb_columns  sp_oledb_getprocedurecolumns  sp_special_columns  sp_sproc_columns  sp_unbindefault  sp_unbindrule 
cdefaultsp_bindefault  sp_depends  sp_depends_cols  sp_drv_bcpmetadata  sp_help  sp_helpconstraint  sp_jdbc_columns  sp_merge_dup_inline_default  sp_odbc_columns  sp_oledb_columns  sp_unbindefault 
domainsp_bindrule  sp_depends  sp_depends_cols  sp_help  sp_helpconstraint  sp_unbindrule 
namesp_addgroup  sp_addobjectdef  sp_addsegment  sp_addtype  sp_adduser  sp_aux_computeprivs  sp_aux_encr_verify_downgrade  sp_bindefault  sp_bindrule  sp_checknames  sp_checkreswords  sp_chgattribute  sp_column_privileges  sp_columns  sp_commonkey  sp_depends  sp_depends_cols  sp_downgrade  sp_dropextendedproc  sp_droptype  sp_drv_bcpmetadata  sp_drv_getcolumnprivileges  sp_encryption  sp_estspace  sp_foreignkey  sp_help  sp_help_params  sp_helpartition  sp_helpcomputedcolumn  sp_helpextendedproc  sp_helpjoins  sp_helpobjectdef  sp_helprotect  sp_ijdbc_aux_computeprivs  sp_ijdbc_columns  sp_ijdbc_getbestrowidentifier  sp_ijdbc_getcolumnprivileges  sp_ijdbc_getprocedurecolumns  sp_ijdbc_getversioncolumns  sp_index_row_size_est  sp_jdbc_columns  sp_jdbc_computeprivs  sp_jdbc_getbestrowidentifier  sp_jdbc_getfunctioncolumns  sp_jdbc_getversioncolumns  sp_modifystats  sp_odbc_columns  sp_odbc_getprocedurecolumns  sp_odbc_getversioncolumns  sp_oledb_columns  sp_oledb_getcolumnprivileges  sp_oledb_getprocedurecolumns  sp_primarykey  sp_rename  sp_setlangalias  sp_setrepcol  sp_special_columns  sp_sproc_columns  sp_unbindefault  sp_unbindrule 
printfmtsp_ijdbc_getprocedurecolumns  sp_jdbc_getfunctioncolumns 
precsp_columns  sp_drv_bcpmetadata  sp_help  sp_help_params  sp_ijdbc_columns  sp_ijdbc_getprocedurecolumns  sp_jdbc_columns  sp_jdbc_getfunctioncolumns  sp_odbc_columns  sp_odbc_getprocedurecolumns  sp_oledb_columns  sp_oledb_getprocedurecolumns  sp_sproc_columns 
scalesp_columns  sp_drv_bcpmetadata  sp_help  sp_help_params  sp_ijdbc_columns  sp_ijdbc_getprocedurecolumns  sp_jdbc_columns  sp_jdbc_getfunctioncolumns  sp_odbc_columns  sp_odbc_getprocedurecolumns  sp_oledb_columns  sp_oledb_getprocedurecolumns  sp_sproc_columns 
xstatussp_bindrule  sp_depends_cols  sp_help  sp_setrepcol  sp_setreplicate  sp_setreptable 
xtypesp_help  sp_help_params  sp_helpjava  sp_ijdbc_columns  sp_jdbc_columns  sp_odbc_columns  sp_odbc_getprocedurecolumns  sp_oledb_getprocedurecolumns  sp_sproc_columns 
xdbidsp_help  sp_help_params  sp_odbc_getprocedurecolumns  sp_oledb_getprocedurecolumns  sp_sproc_columns 
accessrulesp_bindrule  sp_depends  sp_depends_cols  sp_help  sp_unbindrule 
status2sp_aux_encr_verify_downgrade  sp_bindefault  sp_bindrule  sp_drv_bcpmetadata  sp_encryption  sp_help  sp_help_params  sp_helpcomputedcolumn  sp_jdbc_getfunctioncolumns  sp_odbc_getprocedurecolumns  sp_oledb_getprocedurecolumns  sp_setrepcol  sp_setreptable  sp_sproc_columns 
status3sp_bindrule  sp_help  sp_helpcomputedcolumn  sp_rename 
computedcolsp_help  sp_helpcomputedcolumn 
encrkeyidsp_encryption 
encrkeydbsp_encryption 
lobcomp_lvlsp_help 
inrowlensp_drv_bcpmetadata  sp_help 

QUERIES
Joined With Links
sybsystemprocs..sysobjects sybsystemprocs..sysobjects sybsystemprocs..sp_encryption:1322
sybsystemprocs..sysobjects master..spt_values sybsystemprocs..sp_checkreswords:143
sybsystemprocs..sp_checkreswords:193
sybsystemprocs..sp_checkreswords:101
sybsystemprocs..sysobjects sybsystemprocs..sp_drv_getcolumnprivileges:249
sybsystemprocs..sp_encryption:2448
sybsystemprocs..sp_setreplicate:467
sybsystemprocs..sp_helpconfig_process_estimate:98
sybsystemprocs..sp_ijdbc_getcolumnprivileges:146
sybsystemprocs..sp_drv_getcolumnprivileges:249
sybsystemprocs..sp_drv_getcolumnprivileges:249
sybsystemprocs..sp_oledb_getcolumnprivileges:255
sybsystemprocs..sp_oledb_getcolumnprivileges:255
sybsystemprocs..sp_oledb_getcolumnprivileges:255
sybsystemprocs..sp_checknames:282
sybsystemprocs..sp_aux_encr_verify_downgrade:378
sybsystemprocs..sp_ijdbc_getcolumnprivileges:159
sybsystemprocs..sp_rename:364
sybsystemprocs..sp_drv_getcolumnprivileges:249
sybsystemprocs..sp_bindrule:675
sybsystemprocs..sp_unbindrule:707
sybsystemprocs..sp_oledb_getcolumnprivileges:255
master..spt_values master..spt_values sybsystemprocs..sp_helpjoins:279
sybsystemprocs..sp_commonkey:354
sybsystemprocs..sp_foreignkey:567
sybsystemprocs..sp_foreignkey:509
sybsystemprocs..sp_commonkey:329
sybsystemprocs..sp_foreignkey:422
sybsystemprocs..sp_foreignkey:353
sybsystemprocs..sp_foreignkey:393
sybsystemprocs..sp_commonkey:204
sybsystemprocs..sp_commonkey:304
sybsystemprocs..sp_commonkey:229
sybsystemprocs..sp_commonkey:181
sybsystemprocs..sp_foreignkey:480
sybsystemprocs..sp_helpjoins:266
sybsystemprocs..sp_foreignkey:451
sybsystemprocs..sp_commonkey:254
sybsystemprocs..sp_foreignkey:538
sybsystemprocs..sp_commonkey:279
sybsystemprocs..sysobjects sybsystemprocs..sysusers sybsystemprocs..sp_depends:292
sybsystemprocs..sp_droptype:150
sybsystemprocs..sp_helpjoins:241
sybsystemprocs..sp_helpjoins:234
sybsystemprocs..sysobjects sybsystemprocs..systypes sybsystemprocs..sp_bindrule:570
sybsystemprocs..sp_bindrule:604
sybsystemprocs..sp_unbindefault:355
sybsystemprocs..sp_bindefault:420
sybsystemprocs..sp_unbindrule:623
sybsystemprocs..sp_bindrule:635
sybsystemprocs..sp_unbindrule:699
sybsystemprocs..sysindexes sybsystemprocs..sysobjects sybsystemprocs..sp_odbc_getindexinfo:115
sybsystemprocs..sp_statistics:116
sybsystemprocs..sp_oledb_primarykey:70
sybsystemprocs..sp_jdbc_getindexinfo:139
master..sysmessages master..spt_values sybsystemprocs..sp_sproc_columns:510
sybsystemprocs..sp_sproc_columns:394
sybsystemprocs..sp_help_params:73
sybsystemprocs..sp_sproc_columns:694
sybsystemprocs..sp_sproc_columns:220
sybsystemprocs..sysobjects sybsystemprocs..spt_datatype_info 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
master..sysmessages sybsystemprocs..sysobjects master..spt_values sybsystemprocs..sysxtypes sybsystemprocs..sp_helpjava:223
sybsystemprocs..sp_helpjava:289
sybsystemprocs..syscomments sybsystemprocs..sysobjects sybsystemprocs..sp_helpconstraint:208
master..sysdatabases sybsystemprocs..sysobjects sybsystemprocs..sysusers sybsystemprocs..sp_aux_encr_verify_downgrade:294
sybsystemprocs..sysobjects master..systypes sybsystemprocs..sp_aux_encr_verify_downgrade:415
sybsystemprocs..sysobjects sybsystemprocs..spt_datatype_info sybsystemprocs..systypes sybsystemprocs..sp_columns:427
sybsystemprocs..sp_columns:75
sybsystemprocs..sp_columns:186
sybsystemprocs..sp_columns:315
sybsystemprocs..sysobjects sybsystemprocs..spt_jdbc_datatype_info sybsystemprocs..systypes sybsystemprocs..sp_jdbc_getfunctioncolumns:212
sybsystemprocs..sp_jdbc_getfunctioncolumns:91
sybsystemprocs..sp_jdbc_getfunctioncolumns:212
sybsystemprocs..sp_jdbc_getfunctioncolumns:91
sybsystemprocs..sysobjects sybsystemprocs..sysprocedures sybsystemprocs..spt_jdatatype_info sybsystemprocs..sp_ijdbc_getprocedurecolumns:92
sybsystemprocs..systypes sybsystemprocs..sp_bindefault:405
sybsystemprocs..sp_bindrule:618
sybsystemprocs..sp_unbindrule:655
sybsystemprocs..sp_unbindefault:338
sybsystemprocs..sp_unbindrule:667
sybsystemprocs..sp_unbindefault:381
sybsystemprocs..sp_unbindrule:601
sybsystemprocs..sp_unbindrule:678
sybsystemprocs..sp_bindrule:648
sybsystemprocs..sp_bindefault:445
sybsystemprocs..sp_bindrule:547
sybsystemprocs..sysprocedures sybsystemprocs..sp_depends_cols:383
sybsystemprocs..sysattributes sybsystemprocs..sp_help:680
sybsystemprocs..spt_datatype_info sybsystemprocs..sp_special_columns:67
sybsystemprocs..sp_odbc_getversioncolumns:72
sybsystemprocs..spt_jdbc_datatype_info sybsystemprocs..sp_jdbc_getversioncolumns:113
sybsystemprocs..syspartitionkeys sybsystemprocs..sp_helpartition:224
sybsystemprocs..sysindexes sybsystemprocs..syspartitionkeys sybsystemprocs..sp_post_xpload:174
sybsystemprocs..sp_post_xpload:191
sybsystemprocs..sysdepends sybsystemprocs..sysxtypes sybsystemprocs..sp_helpjava:194

COLUMN WRITES detailed
ColumnWritten From
status  syscolumns.status   sp_unbindrule.@?   sp_bindrule.@?   sp_setreptable.@?   sp_rename.@?   sp_setreplicate.@?  
cdefault  syscomments.id   systypes.tdefault   sp_unbindefault.@?   sp_bindefault.@defname   sp_bindefault.@?   sp_addtype.@?  
domain  sysconstraints.constrid   systypes.domain   sp_unbindrule.@?   sp_bindrule.@?   sp_bindrule.@rulename   sp_addtype.@?  
name  sp_rename.@newname  
accessrule  systypes.accessrule   sp_unbindrule.@?   sp_bindrule.@?   sp_bindrule.@rulename   sp_addtype.@?  
status2  syscolumns.status2   sp_setreptable.@?  

DATA PROPAGATION detailed
ColumnWritten To
cdefaultsp_oledb_columns_rset_001.COLUMN_HASDEFAULT sp_oledb_columns_rset_002.COLUMN_HASDEFAULT
colidsyskeys.key1   °.key2   °.key3   °.key4   °.key5   °.key6   °.key7   °.key8   °.depkey1   °.depkey2  
°.depkey3   °.depkey4   °.depkey5   °.depkey6   °.depkey7   °.depkey8   sp_columns_rset_001.colid °.ordinal_position sp_columns_rset_002.colid °.ordinal_position
sp_jdbc_getbestrowidentifier_rset_001.COLUMN_NAME sp_jdbc_getindexinfo_rset_001.ORDINAL_POSITION °.COLUMN_NAME sp_jdbc_getindexinfo_rset_002.ORDINAL_POSITION °.COLUMN_NAME sp_odbc_getindexinfo_rset_001.ORDINAL_POSITION °.COLUMN_NAME °.ASC_OR_DESC sp_odbc_getindexinfo_rset_002.ORDINAL_POSITION °.COLUMN_NAME
°.ASC_OR_DESC sp_odbc_getprocedurecolumns_rset_001.ORDINAL_POSITION sp_odbc_getprocedurecolumns_rset_002.ORDINAL_POSITION sp_odbc_getversioncolumns_rset_001.COLUMN_NAME sp_oledb_getprocedurecolumns_rset_001.ORDINAL_POSITION sp_oledb_getprocedurecolumns_rset_002.ORDINAL_POSITION sp_oledb_primarykey_rset_001.COLUMN_NAME °.ORDINAL sp_special_columns_rset_001.column_name sp_sproc_columns_rset_001.colid
°.ordinal_position sp_sproc_columns_rset_002.colid °.ordinal_position sp_statistics_rset_001.seq_in_index °.column_name °.collation sp_statistics_rset_002.seq_in_index °.column_name °.collation
lengthsp_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_estspace_rset_001.Total_Mbytes sp_estspace_rset_002.Total_Mbytes sp_jdbc_getbestrowidentifier_rset_001.DATA_TYPE °.TYPE_NAME °.COLUMN_SIZE °.DECIMAL_DIGITS
sp_jdbc_getversioncolumns_rset_001.COLUMN_SIZE °.DECIMAL_DIGITS 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
namesp_checknames_rset_005.name sp_columns_rset_001.column_name sp_columns_rset_002.column_name sp_droptype_rset_001.column sp_jdbc_getversioncolumns_rset_001.COLUMN_NAME sp_modifystats_rset_001.sqlbNoName58 sp_modifystats_rset_002.sqlbNoName59 sp_modifystats_rset_003.sqlbNoName60 sp_odbc_getprocedurecolumns_rset_001.COLUMN_NAME sp_odbc_getprocedurecolumns_rset_002.COLUMN_NAME
sp_odbc_getversioncolumns_rset_002.COLUMN_NAME sp_odbc_getversioncolumns_rset_003.COLUMN_NAME sp_oledb_columns_rset_001.COLUMN_NAME sp_oledb_columns_rset_002.COLUMN_NAME sp_oledb_getprocedurecolumns_rset_001.PARAMETER_NAME sp_oledb_getprocedurecolumns_rset_002.PARAMETER_NAME sp_special_columns_rset_002.column_name sp_special_columns_rset_003.column_name sp_sproc_columns_rset_001.column_name sp_sproc_columns_rset_002.column_name
numbersp_sproc_columns_rset_001.procedure_name sp_sproc_columns_rset_002.procedure_name
precsp_columns_rset_001.precision °.char_octet_length sp_columns_rset_002.precision °.char_octet_length sp_odbc_getprocedurecolumns_rset_001.COLUMN_SIZE °.CHAR_OCTET_LENGTH sp_odbc_getprocedurecolumns_rset_002.COLUMN_SIZE °.CHAR_OCTET_LENGTH sp_oledb_columns_rset_001.NUMERIC_PRECISION sp_oledb_columns_rset_002.NUMERIC_PRECISION
sp_oledb_getprocedurecolumns_rset_001.CHARACTER_MAXIMUM_LENGTH °.CHARACTER_OCTET_LENGTH sp_oledb_getprocedurecolumns_rset_002.CHARACTER_MAXIMUM_LENGTH °.CHARACTER_OCTET_LENGTH sp_sproc_columns_rset_001.precision °.char_octet_length sp_sproc_columns_rset_002.precision °.char_octet_length
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_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_sproc_columns_rset_001.scale sp_sproc_columns_rset_002.scale
statussyscolumns.status   sp_columns_rset_001.type_name °.nullable °.is_nullable sp_columns_rset_002.type_name °.nullable °.is_nullable sp_oledb_columns_rset_001.COLUMN_FLAGS °.IS_NULLABLE sp_oledb_columns_rset_002.COLUMN_FLAGS
°.IS_NULLABLE sp_sproc_columns_rset_001.nullable °.is_nullable sp_sproc_columns_rset_002.nullable °.is_nullable
status2syscolumns.status2  
typesp_columns_rset_001.ss_data_type °.char_octet_length sp_columns_rset_002.ss_data_type °.char_octet_length sp_odbc_getprocedurecolumns_rset_001.CHAR_OCTET_LENGTH sp_odbc_getprocedurecolumns_rset_002.CHAR_OCTET_LENGTH sp_oledb_getprocedurecolumns_rset_001.CHARACTER_OCTET_LENGTH sp_oledb_getprocedurecolumns_rset_002.CHARACTER_OCTET_LENGTH sp_sproc_columns_rset_001.ss_data_type °.char_octet_length
sp_sproc_columns_rset_002.ss_data_type °.char_octet_length

DEPENDENCIES
READERS AND WRITERS
read by proc sybsystemprocs..sp_jdbc_getfunctioncolumns  
read by proc sybsystemprocs..sp_oledb_getprocedurecolumns  
read_written by proc sybsystemprocs..sp_bindrule  
read_written by proc sybsystemprocs..sp_rename  
read by proc sybsystemprocs..sp_drv_getcolumnprivileges  
   called by proc sybsystemprocs..sp_jdbc_getcolumnprivileges  
   called by proc sybsystemprocs..sp_odbc_getcolumnprivileges  
read by proc sybsystemprocs..sp_spaceusage_object_populate  
   called by proc sybsystemprocs..sp_spaceusage_object  
      called by proc sybsystemprocs..sp_spaceusage  
read by proc sybsystemprocs..sp_helprotect  
read by proc sybsystemprocs..sp_helpconfig_process_estimate  
   called by proc sybsystemprocs..sp_helpconfig_est_compinfo_poolsize  
read by proc sybsystemprocs..sp_downgrade  
read by proc sybsystemprocs..sp_droptype  
read by proc sybsystemprocs..sp_setlangalias  
read_written by proc sybsystemprocs..sp_unbindefault  
read by proc sybsystemprocs..sp_helpjava  
read by proc sybsystemprocs..sp_ijdbc_getversioncolumns  
read by proc sybsystemprocs..sp_jdbc_getindexinfo  
read by proc sybsystemprocs..sp_addsegment  
read by proc sybsystemprocs..sp_ijdbc_columns  
read by proc sybsystemprocs..sp_drv_bcpmetadata  
read by proc sybsystemprocs..sp_odbc_getprocedurecolumns  
read by proc sybsystemprocs..sp_oledb_getcolumnprivileges  
read_written by proc sybsystemprocs..sp_setreplicate  
read by proc sybsystemprocs..sp_post_xpload  
read by proc sybsystemprocs..sp_addtype  
read by proc sybsystemprocs..sp_encryption  
   called by proc sybsystemprocs..sp_downgrade  
read by proc sybsystemprocs..sp_jdbc_columns  
read by proc sybsystemprocs..sp_helpconstraint  
read by proc sybsystemprocs..sp_columns  
read by proc sybsystemprocs..sp_estspace  
read by proc sybsystemprocs..sp_jdbc_getversioncolumns  
read by proc sybsystemprocs..sp_aux_computeprivs  
   called by proc sybsystemprocs..sp_table_privileges  
   called by proc sybsystemprocs..sp_column_privileges  
read by proc sybsystemprocs..sp_ijdbc_aux_computeprivs  
read by proc sybsystemprocs..sp_addobjectdef  
   called by proc sybsystemprocs..sp_addtabledef  
read by proc sybsystemprocs..sp_ijdbc_getprocedurecolumns  
read by proc sybsystemprocs..sp_odbc_getindexinfo  
read by proc sybsystemprocs..sp_sproc_columns  
read by proc sybsystemprocs..sp_checkreswords  
read by proc sybsystemprocs..sp_oledb_columns  
read by proc sybsystemprocs..sp_dropuser  
read by proc sybsystemprocs..sp_jdbc_getbestrowidentifier  
read by proc sybsystemprocs..sp_odbc_getversioncolumns  
read by proc sybsystemprocs..sp_odbc_columns  
read by proc sybsystemprocs..sp_column_privileges  
read by proc sybsystemprocs..sp_setrepproc  
read by proc sybsystemprocs..sp_special_columns  
read by proc sybsystemprocs..sp_aux_encr_verify_downgrade  
read by proc sybsystemprocs..sp_ijdbc_getindexinfo  
read by proc sybsystemprocs..sp_chgattribute  
read by proc sybsystemprocs..sp_primarykey  
read by proc sybsystemprocs..sp_depends_cols  
   called by proc sybsystemprocs..sp_depends  
read_written by proc sybsystemprocs..sp_bindefault  
read by proc sybsystemprocs..sp_commonkey  
read by proc sybsystemprocs..sp_dropextendedproc  
read by proc sybsystemprocs..sp_ijdbc_getbestrowidentifier  
read by proc sybsystemprocs..sp_helpcomputedcolumn  
   called by proc sybsystemprocs..sp_helpindex  
      called by proc sybsystemprocs..sp_help  
   called by proc sybsystemprocs..sp_help  
read by proc sybsystemprocs..sp_addgroup  
read by proc sybsystemprocs..sp_helpartition  
   called by proc sybsystemprocs..sp_help  
read by proc sybsystemprocs..sp_checknames  
read by proc sybsystemprocs..sp_foreignkey  
read by proc sybsystemprocs..sp_helpextendedproc  
written by proc sybsystemprocs..sp_setreptable  
read by proc sybsystemprocs..sp_helpobjectdef  
read by proc sybsystemprocs..sp_depends  
read by proc sybsystemprocs..sp_oledb_primarykey  
read by proc sybsystemprocs..sp_adduser  
read by proc sybsystemprocs..sp_help_params  
   called by proc sybsystemprocs..sp_help  
   called by proc sybsystemprocs..sp_showtext_sproc_tagline  
      called by proc sybsystemprocs..sp_showtext_output  
         called by proc sybsystemprocs..sp_showtext  
            called by proc sybsystemprocs..sp_helptext_usage  
               called by proc sybsystemprocs..sp_helptext  
            called by proc sybsystemprocs..sp_helptext  
written by proc sybsystemprocs..sp_merge_dup_inline_default  
read by proc sybsystemprocs..sp_setrepcol  
read by proc sybsystemprocs..sp_modifystats  
read by proc sybsystemprocs..sp_helpjoins  
read by proc sybsystemprocs..sp_changegroup  
read by proc sybsystemprocs..sp_ijdbc_getcolumnprivileges  
read_written by proc sybsystemprocs..sp_unbindrule  
read by proc sybsystemprocs..sp_help  
read by proc sybsystemprocs..sp_index_row_size_est  
   called by proc sybsystemprocs..sp_spaceusage_object_populate  
read by proc sybsystemprocs..sp_statistics  
read by proc sybsystemprocs..sp_jdbc_computeprivs