DatabaseTableApplicationCreatedLinks
masterspt_values  31 Aug 14Joins Schema ColumnUsage Queries Dependencies

1     create table spt_values(-- 0 Rows, Data: 2 KB, Index: 2 KB
2         name varchar(28) null,
3         number int not null,
4         type char(2) not null,
5         ansi_w tinyint null,
6         low int null,
7         high int null,
8         msgnum int null
9     )
10    
11    create clustered index spt_valuesclust on spt_values(-- 68 KB refcount: 507
12        number, type
13    )
14    
15    Grant Select on spt_values to public
16    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[msgnum]master..sysmessages[error]84 Simple Join
[number]master..spt_values[number]80 Simple Join
[low]sybsystemprocs..syscolumns[type]72 Simple Join
[number]sybsystemprocs..sysobjects[sysstat]24 Simple Join
[number]master..syslocks[context]20 Simple Join
[number]master..syslocks[type]20 Simple Join
[number]master..systransactions[connection]12 Simple Join
[number]master..systransactions[coordinator]12 Simple Join
[number]master..systransactions[failover]12 Simple Join
[number]master..systransactions[state]12 Simple Join
[number]master..systransactions[type]12 Simple Join
[number]sybsystemprocs..syscolumns[status2]10 Simple Join
[number]sybsystemprocs..sysindexes[partitiontype]10 Simple Join
[number]sybsystemprocs..sysobjects[userstat]10 Simple Join
[name]sybsystemprocs..systypes[name]6 FK
[low]master..sysattributes[object_info1]6 Simple Join
[number]sybsystemprocs..sysattributes[object_info2]6 Simple Join
[name]sybsystemprocs..syscolumns[name]6 Simple Join
[name]sybsystemprocs..sysindexes[name]6 Simple Join
[name]sybsystemprocs..sysobjects[name]6 Simple Join
[name]master..syscharsets[name]4 FK
[name]master..sysdatabases[name]4 FK
[name]master..sysdevices[name]4 FK
[name]master..syslanguages[name]4 FK
[name]master..syslogins[name]4 FK
[name]master..sysservers[srvname]4 FK
[name]sybsystemprocs..sysusers[name]4 FK
[name]master..sysattributes[object_cinfo]4 Simple Join
[name]master..sysremotelogins[remoteusername]4 Simple Join
[number]master..sysremotelogins[status]4 Simple Join
[name]master..sysservers[srvnetname]4 Simple Join
[number]sybsystemprocs..syskeys[type]4 Simple Join
[name]sybsystemprocs..syssegments[name]4 Simple Join
[number]master..syssrvroles[srid]2 FK
[number]sybsystemprocs..sysdepends[readobj]2 Simple Join
[number]sybsystemprocs..sysdepends[resultobj]2 Simple Join

Estimated Index Usage
spt_values.spt_valuesclust clustered(number, type)507

ALIASES USED for master..spt_values
NO_ALIASabcdsuvv1v2v3v4v5viwxyz
132641146114316176665161818

SCHEMA

COLUMN USAGE
namesp_addlogin  sp_addobjectdef  sp_addserver  sp_addtabledef  sp_addtype  sp_addumpdevice  sp_aux_get_concrtlyownedobj  sp_bindcache  sp_changedbowner  sp_checkreswords  sp_chgattribute  sp_configure  sp_config_rep_agent  sp_dboption  sp_dbrecovery_order  sp_ddlgen_database  sp_ddlgen_permissions  sp_defaultloc  sp_depends  sp_deviceattr  sp_displaylogin  sp_downgrade  sp_dropsegment  sp_dropuser  sp_estspace  sp_extendsegment  sp_familylock  sp_fixindex  sp_help  sp_helpartition  sp_helpcache  sp_helpdb  sp_helpindex  sp_helpkey  sp_helpmaplogin  sp_helpobjectdef  sp_helpremotelogin  sp_helprotect  sp_helpserver  sp_helpsort  sp_helpuser  sp_help_rep_agent  sp_lock  sp_logdevice  sp_logiosize  sp_maplogin  sp_merge_dup_inline_default  sp_modifylogin  sp_monitor_procstack  sp_multdb_addtogroup  sp_multdb_bind  sp_multdb_removefromgroup  sp_multdb_show  sp_multdb_unbindall_db  sp_passwordpolicy  sp_placeobject  sp_plan_dbccdb  sp_remoteoption  sp_renamedb  sp_serveroption  sp_setrepdbmode  sp_setrepdefmode  sp_setreplicate  sp_show_options  sp_tab_suspectptn  sp_transactions  sp_tran_dumpable_status  sp_update_authmech_value 
numbersp_addlogin  sp_addobjectdef  sp_addsegment  sp_addserver  sp_addthreshold  sp_addtype  sp_aux_get_concrtlyownedobj  sp_bindcache  sp_changedbowner  sp_checkreswords  sp_chgattribute  sp_commonkey  sp_configure  sp_config_rep_agent  sp_dboption  sp_dbrecovery_order  sp_ddlgen_database  sp_ddlgen_permissions  sp_defaultloc  sp_depends  sp_depends_cols  sp_deviceattr  sp_downgrade  sp_dropsegment  sp_dropuser  sp_estspace  sp_extendsegment  sp_familylock  sp_fixindex  sp_foreignkey  sp_help  sp_helpartition  sp_helpcache  sp_helpdb  sp_helpdevice  sp_helpindex  sp_helpjava  sp_helpjoins  sp_helpkey  sp_helpobjectdef  sp_helpremotelogin  sp_helprotect  sp_helpsegment  sp_helpserver  sp_helpsort  sp_helpuser  sp_help_params  sp_help_rep_agent  sp_ijdbc_getcolumnprivileges  sp_lock  sp_logdevice  sp_logiosize  sp_maplogin  sp_merge_dup_inline_default  sp_modifylogin  sp_modifythreshold  sp_monitor_procstack  sp_multdb_addtogroup  sp_multdb_bind  sp_multdb_removefromgroup  sp_multdb_show  sp_multdb_unbindall_db  sp_placeobject  sp_plan_dbccdb  sp_remoteoption  sp_renamedb  sp_serveroption  sp_setrepdbmode  sp_setrepdefmode  sp_setreplicate  sp_show_options  sp_spaceused  sp_sproc_columns  sp_tab_suspectptn  sp_transactions  sp_tran_dumpable_status 
typesp_addlogin  sp_addobjectdef  sp_addsegment  sp_addserver  sp_addtabledef  sp_addthreshold  sp_addumpdevice  sp_aux_get_concrtlyownedobj  sp_bindcache  sp_changedbowner  sp_checkreswords  sp_chgattribute  sp_commonkey  sp_configure  sp_config_rep_agent  sp_dboption  sp_dbrecovery_order  sp_ddlgen_database  sp_ddlgen_permissions  sp_defaultloc  sp_depends  sp_depends_cols  sp_deviceattr  sp_displaylogin  sp_downgrade  sp_dropsegment  sp_dropuser  sp_estspace  sp_extendsegment  sp_familylock  sp_fixindex  sp_foreignkey  sp_help  sp_helpartition  sp_helpcache  sp_helpdb  sp_helpdevice  sp_helpindex  sp_helpjava  sp_helpjoins  sp_helpkey  sp_helpmaplogin  sp_helpobjectdef  sp_helpremotelogin  sp_helprotect  sp_helpsegment  sp_helpserver  sp_helpsort  sp_helpuser  sp_help_rep_agent  sp_ijdbc_getcolumnprivileges  sp_lock  sp_logdevice  sp_logiosize  sp_maplogin  sp_merge_dup_inline_default  sp_modifylogin  sp_modifythreshold  sp_monitor_procstack  sp_multdb_addtogroup  sp_multdb_bind  sp_multdb_removefromgroup  sp_multdb_show  sp_multdb_unbindall_db  sp_passwordpolicy  sp_placeobject  sp_plan_dbccdb  sp_remoteoption  sp_renamedb  sp_serveroption  sp_setrepdbmode  sp_setrepdefmode  sp_setreplicate  sp_show_options  sp_spaceused  sp_tab_suspectptn  sp_transactions  sp_tran_dumpable_status  sp_update_authmech_value 
ansi_wsp_configure 
lowsp_addlogin  sp_addsegment  sp_addthreshold  sp_changedbowner  sp_commonkey  sp_configure  sp_ddlgen_database  sp_depends  sp_depends_cols  sp_deviceattr  sp_displaylogin  sp_dropsegment  sp_dropuser  sp_estspace  sp_extendsegment  sp_foreignkey  sp_helpdb  sp_helpdevice  sp_helpjoins  sp_helpmaplogin  sp_helprotect  sp_helpsegment  sp_helpsort  sp_ijdbc_getcolumnprivileges  sp_maplogin  sp_modifylogin  sp_modifythreshold  sp_passwordpolicy  sp_show_options  sp_spaceused  sp_tran_dumpable_status  sp_update_authmech_value 
highsp_changedbowner  sp_configure  sp_depends  sp_depends_cols  sp_dropuser  sp_helprotect  sp_helpsort  sp_ijdbc_getcolumnprivileges  sp_passwordpolicy  sp_show_options  sp_tran_dumpable_status 
msgnumsp_aux_get_concrtlyownedobj  sp_configure  sp_dboption  sp_depends  sp_help  sp_helpdb  sp_helpdevice  sp_helpjava  sp_helpremotelogin  sp_helpuser  sp_help_params  sp_passwordpolicy  sp_remoteoption  sp_setreplicate  sp_sproc_columns 

QUERIES
Joined With Links
sybsystemprocs..sysobjects sybsystemprocs..sp_checkreswords:158
sybsystemprocs..sp_checkreswords:118
sybsystemprocs..sysobjects sybsystemprocs..sp_checkreswords:220
sybsystemprocs..sp_show_options:12
sybsystemprocs..sp_tran_dumpable_status:21
sybsystemprocs..syscolumns sybsystemprocs..sysobjects sybsystemprocs..sp_checkreswords:140
sybsystemprocs..sp_checkreswords:98
sybsystemprocs..sp_checkreswords:190
sybsystemprocs..syscolumns sybsystemprocs..syscolumns sybsystemprocs..sp_commonkey:229
sybsystemprocs..sp_foreignkey:353
sybsystemprocs..sp_foreignkey:393
sybsystemprocs..sp_foreignkey:451
sybsystemprocs..sp_foreignkey:422
sybsystemprocs..sp_commonkey:354
sybsystemprocs..sp_commonkey:279
sybsystemprocs..sp_helpjoins:279
sybsystemprocs..sp_helpjoins:266
sybsystemprocs..sp_foreignkey:567
sybsystemprocs..sp_foreignkey:480
sybsystemprocs..sp_foreignkey:538
sybsystemprocs..sp_commonkey:304
sybsystemprocs..sp_commonkey:181
sybsystemprocs..sp_commonkey:204
sybsystemprocs..sp_foreignkey:509
sybsystemprocs..sp_commonkey:254
sybsystemprocs..sp_commonkey:329
master..systransactions sybsystemprocs..sp_transactions:95
sybsystemprocs..sp_transactions:266
sybsystemprocs..sp_transactions:141
sybsystemprocs..sp_transactions:314
sybsystemprocs..sp_transactions:63
sybsystemprocs..sp_transactions:290
master..sysmessages sybsystemprocs..sysobjects sybsystemprocs..sp_help:114
sybsystemprocs..sp_help:280
sybsystemprocs..sp_setreplicate:176
sybsystemprocs..sp_aux_get_concrtlyownedobj:22
sybsystemprocs..sysindexes sybsystemprocs..sysobjects sybsystemprocs..sp_checkreswords:108
sybsystemprocs..sp_checkreswords:205
sybsystemprocs..sp_checkreswords:149
master..sysmessages sybsystemprocs..sysobjects sybsystemprocs..sysusers sybsystemprocs..sp_helpuser:94
master..syslocks sybsystemprocs..sp_lock:132
sybsystemprocs..sp_lock:69
sybsystemprocs..sp_lock:155
sybsystemprocs..sp_lock:110
sybsystemprocs..sp_lock:95
sybsystemprocs..sp_lock:52
sybsystemprocs..systypes sybsystemprocs..sp_checkreswords:236
sybsystemprocs..sp_checkreswords:165
sybsystemprocs..sp_checkreswords:126
sybsystemprocs..syscolumns master..sysmessages sybsystemprocs..sp_sproc_columns:694
sybsystemprocs..sp_help_params:73
sybsystemprocs..sp_sproc_columns:394
sybsystemprocs..sp_sproc_columns:510
sybsystemprocs..sp_sproc_columns:220
sybsystemprocs..sysindexes sybsystemprocs..sysobjects sybsystemprocs..sysusers sybsystemprocs..sp_tab_suspectptn:69
sybsystemprocs..sysindexes sybsystemprocs..sp_helpartition:109
sybsystemprocs..sysusers sybsystemprocs..sp_checkreswords:272
sybsystemprocs..sp_checkreswords:276
sybsystemprocs..syscolumns master..sysmessages sybsystemprocs..sysobjects sybsystemprocs..sysxtypes sybsystemprocs..sp_helpjava:289
sybsystemprocs..sp_helpjava:223
master..sysdevices sybsystemprocs..sp_checkreswords:357
sybsystemprocs..sp_checkreswords:353
master..sysmessages sybsystemprocs..sp_remoteoption:318
sybsystemprocs..sp_dboption:551
sybsystemprocs..sp_dboption:239
sybsystemprocs..sp_dboption:537
sybsystemprocs..sp_dboption:607
sybsystemprocs..sp_dboption:517
sybsystemprocs..sp_remoteoption:277
sybsystemprocs..sp_dboption:696
sybsystemprocs..sp_remoteoption:148
sybsystemprocs..sp_remoteoption:225
master..sysattributes sybsystemprocs..sp_maplogin:444
sybsystemprocs..sp_maplogin:413
sybsystemprocs..sp_helpmaplogin:51
master..sysservers sybsystemprocs..sp_checkreswords:379
sybsystemprocs..sp_checkreswords:383
sybsystemprocs..sp_checkreswords:391
sybsystemprocs..sp_checkreswords:395
sybsystemprocs..sysdepends sybsystemprocs..sysobjects sybsystemprocs..sysusers sybsystemprocs..sp_depends:213
master..syslogins sybsystemprocs..sp_checkreswords:305
sybsystemprocs..sp_checkreswords:309
sybsystemprocs..syssegments sybsystemprocs..sp_checkreswords:289
sybsystemprocs..sp_checkreswords:285
master..sysdatabases sybsystemprocs..sp_checkreswords:333
sybsystemprocs..sp_checkreswords:329
master..sysremotelogins sybsystemprocs..sp_checkreswords:369
sybsystemprocs..sp_checkreswords:365
sybsystemprocs..sysattributes sybsystemprocs..sp_helpobjectdef:188
sybsystemprocs..sp_helpobjectdef:214
sybsystemprocs..sp_helpobjectdef:51
sybsystemprocs..sysdepends master..sysmessages master..sysmessages master..sysmessages sybsystemprocs..sysobjects sybsystemprocs..sysusers sybsystemprocs..sp_depends:171
sybsystemprocs..sysindexes sybsystemprocs..sysobjects sybsystemprocs..syspartitions sybsystemprocs..sysusers sybsystemprocs..sp_tab_suspectptn:128
master..syscharsets sybsystemprocs..sp_checkreswords:321
sybsystemprocs..sp_checkreswords:317
master..syslanguages sybsystemprocs..sp_checkreswords:345
sybsystemprocs..sp_checkreswords:341
sybsystemprocs..syskeys sybsystemprocs..sp_helpkey:132
sybsystemprocs..sp_helpkey:71
sybsystemprocs..sysdepends master..sysmessages sybsystemprocs..sysobjects sybsystemprocs..sysxtypes sybsystemprocs..sp_helpjava:272
sybsystemprocs..sp_helpjava:205
master..sysattributes master..sysmessages sybsystemprocs..sp_passwordpolicy:296
sybsystemprocs..sp_passwordpolicy:310
master..sysremotelogins master..sysservers sybsystemprocs..sp_helpremotelogin:142
master..sysmessages master..sysremotelogins master..sysservers sybsystemprocs..sp_helpremotelogin:161

DEPENDENCIES
READERS AND WRITERS
read by proc sybsystemprocs..sp_helprotect  
read by proc sybsystemprocs..sp_addtype  
read by proc sybsystemprocs..sp_chgattribute  
read by proc sybsystemprocs..sp_helpserver  
read by proc sybsystemprocs..sp_helpcache  
read by proc sybsystemprocs..sp_dropuser  
read by proc sybsystemprocs..sp_passwordpolicy  
   called by proc sybsystemprocs..sp_downgrade  
read by proc sybsystemprocs..sp_helpobjectdef  
read by proc sybsystemprocs..sp_multdb_show  
   called by proc sybsystemprocs..sp_tempdb  
read by proc sybsystemprocs..sp_renamedb  
read by proc sybsystemprocs..sp_lock  
read by proc sybsystemprocs..sp_helpartition  
   called by proc sybsystemprocs..sp_help  
read by proc sybsystemprocs..sp_setrepdefmode  
read by proc sybsystemprocs..sp_multdb_removefromgroup  
   called by proc sybsystemprocs..sp_tempdb  
read by proc sybsystemprocs..sp_ddlgen_permissions  
read by proc sybsystemprocs..sp_addserver  
read by proc sybsystemprocs..sp_placeobject  
read by proc sybsystemprocs..sp_downgrade  
read by proc sybsystemprocs..sp_update_authmech_value  
read by proc sybsystemprocs..sp_dbrecovery_order  
read by proc sybsystemprocs..sp_help_rep_agent  
read by proc sybsystemprocs..sp_addtabledef  
read by proc sybsystemprocs..sp_helpsegment  
read by proc sybsystemprocs..sp_addobjectdef  
   called by proc sybsystemprocs..sp_addtabledef  
read by proc sybsystemprocs..sp_multdb_bind  
   called by proc sybsystemprocs..sp_tempdb  
read by proc sybsystemprocs..sp_remoteoption  
read by proc sybsystemprocs..sp_serveroption  
read by proc sybsystemprocs..sp_ddlgen_database  
read by proc sybsystemprocs..sp_modifythreshold  
read by proc sybsystemprocs..sp_setreplicate  
read by proc sybsystemprocs..sp_merge_dup_inline_default  
read by proc sybsystemprocs..sp_ijdbc_getcolumnprivileges  
read by proc sybsystemprocs..sp_helpjava  
read by proc sybsystemprocs..sp_familylock  
read by proc sybsystemprocs..sp_logiosize  
read by proc sybsystemprocs..sp_displaylogin  
read by proc sybsystemprocs..sp_addsegment  
read by proc sybsystemprocs..sp_tab_suspectptn  
read by proc sybsystemprocs..sp_tran_dumpable_status  
read by proc sybsystemprocs..sp_maplogin  
read by proc sybsystemprocs..sp_helpjoins  
read by proc sybsystemprocs..sp_addthreshold  
read by proc sybsystemprocs..sp_multdb_addtogroup  
   called by proc sybsystemprocs..sp_tempdb  
read by proc sybsystemprocs..sp_helpindex  
   called by proc sybsystemprocs..sp_help  
read by proc sybsystemprocs..sp_dropsegment  
read by proc sybsystemprocs..sp_depends_cols  
   called by proc sybsystemprocs..sp_depends  
read by proc sybsystemprocs..sp_configure  
   called by proc sybsystemprocs..sp_configure  
   called by proc sybsystemprocs..sp_setlockpromote  
      called by proc sybsystemprocs..sp_setrowlockpromote  
      called by proc sybsystemprocs..sp_setpglockpromote  
read by proc sybsystemprocs..sp_deviceattr  
read by proc sybsystemprocs..sp_help  
read by proc sybsystemprocs..sp_setrepdbmode  
read by proc sybsystemprocs..sp_aux_get_concrtlyownedobj  
read by proc sybsystemprocs..sp_extendsegment  
read by proc sybsystemprocs..sp_helpmaplogin  
read by proc sybsystemprocs..sp_helpkey  
   called by proc sybsystemprocs..sp_help  
read_written by proc sybsystemprocs..sp_helpsort  
read by proc sybsystemprocs..sp_helpdevice  
read by proc sybsystemprocs..sp_show_options  
read by proc sybsystemprocs..sp_commonkey  
read by proc sybsystemprocs..sp_modifylogin  
read by proc sybsystemprocs..sp_depends  
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  
            called by proc sybsystemprocs..sp_helptext_usage  
               called by proc sybsystemprocs..sp_helptext  
read by proc sybsystemprocs..sp_helpremotelogin  
read by proc sybsystemprocs..sp_fixindex  
read by proc sybsystemprocs..sp_helpuser  
read by proc sybsystemprocs..sp_monitor_procstack  
read by proc sybsystemprocs..sp_changedbowner  
read by proc sybsystemprocs..sp_plan_dbccdb  
read by proc sybsystemprocs..sp_multdb_unbindall_db  
   called by proc sybsystemprocs..sp_tempdb  
read by proc sybsystemprocs..sp_config_rep_agent  
read by proc sybsystemprocs..sp_logdevice  
read by proc sybsystemprocs..sp_addumpdevice  
read by proc sybsystemprocs..sp_sproc_columns  
read by proc sybsystemprocs..sp_dboption  
read by proc sybsystemprocs..sp_defaultloc  
read by proc sybsystemprocs..sp_addlogin  
read by proc sybsystemprocs..sp_estspace  
read by proc sybsystemprocs..sp_checkreswords  
read by proc sybsystemprocs..sp_foreignkey  
read by proc sybsystemprocs..sp_bindcache  
   called by proc sybsystemprocs..sp_unbindcache  
read by proc sybsystemprocs..sp_spaceused  
read by proc sybsystemprocs..sp_transactions  
read by proc sybsystemprocs..sp_helpdb