DatabaseTableApplicationCreatedLinks
mastersyscurconfigs  31 Aug 14Joins Schema ColumnUsage Queries Dependencies

1     create table syscurconfigs(-- 0 Rows, Data: 0 B, Index: 0 B
2         config smallint not null,
3         value int not null,
4         comment varchar(255) not null,
5         status int not null,
6         value2 varchar(255) null,
7         defvalue varchar(255) null,
8         minimum_value int null,
9         maximum_value int null,
10        memory_used int null,
11        display_level int null,
12        datatype int null,
13        message_num int null,
14        apf_percent int null,
15        unit varchar(20) null,
16        type varchar(10) null,
17        nodeid tinyint null
18    )
19    
20    Grant Select on syscurconfigs to public
21    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[config]master..sysconfigures[config]40 Simple Join
[config, comment]master..sysconfigures[config, name]12 Simple Join
[config]master..sysattributes[object]2 Simple Join

ALIASES USED for master..syscurconfigs
NO_ALIASabccccucurrs
425710411311

SCHEMA

COLUMN USAGE
configsp_addlogin  sp_add_resource_limit  sp_aux_encr_verify_downgrade  sp_cacheconfig  sp_configure  sp_countmetadata  sp_downgrade  sp_do_poolconfig  sp_help  sp_helpartition  sp_helpcache  sp_helpcomputedcolumn  sp_helpconfig  sp_helpserver  sp_helpsort  sp_helptext  sp_ijdbc_getxacoordinator  sp_maplogin  sp_modifylogin  sp_monitorconfig  sp_monitor_getcfgval  sp_monitor_list  sp_monitor_list_montypes  sp_opt_querystats_main  sp_serverinfo  sp_shmdumpdisp  sp_shmdumpsize  sp_showtext  sp_sysmon  sp_sysmon_collect  sp_sysmon_dcachestats  sp_sysmon_kernel  sp_validateconfigname 
valuesp_addlogin  sp_add_resource_limit  sp_cacheconfig  sp_configure  sp_countmetadata  sp_downgrade  sp_do_poolconfig  sp_help  sp_helpartition  sp_helpcache  sp_helpcomputedcolumn  sp_helpconfig  sp_helpserver  sp_helpsort  sp_helptext  sp_ijdbc_getxacoordinator  sp_index_space_est  sp_maplogin  sp_modifylogin  sp_monitorconfig  sp_monitor_getcfgval  sp_monitor_list  sp_monitor_list_montypes  sp_opt_querystats_main  sp_serverinfo  sp_shmdumpdisp  sp_shmdumpsize  sp_showtext  sp_sysmon  sp_sysmon_collect  sp_sysmon_dcachestats  sp_sysmon_kernel  sp_validateconfigname 
commentsp_cacheconfig  sp_configure  sp_do_poolconfig  sp_helpcache  sp_helpconfig  sp_index_space_est  sp_shmdumpdisp  sp_shmdumpsize  sp_sysmon  sp_sysmon_dcachestats 
statussp_cacheconfig  sp_helpconfig  sp_sysmon 
value2sp_configure  sp_do_poolconfig  sp_helpconfig  sp_validateconfigname 
defvaluesp_aux_encr_verify_downgrade  sp_configure  sp_helpconfig 
minimum_valuesp_countmetadata  sp_helpconfig 
maximum_valuesp_countmetadata  sp_helpconfig 
memory_usedsp_cacheconfig  sp_do_poolconfig  sp_helpcache  sp_sysmon_dcachestats 
display_levelsp_configure 
datatypesp_helpconfig 
message_numsp_helpconfig 
apf_percentsp_cacheconfig  sp_sysmon_dcachestats 
unitsp_configure  sp_helpconfig 
typesp_configure  sp_helpconfig  sp_monitor_list  sp_monitor_list_montypes 

QUERIES
Joined With Links
master..sysattributes sybsystemprocs..sp_configure:1803
master..sysconfigures sybsystemprocs..sp_helpserver:430
sybsystemprocs..sp_configure:1634
sybsystemprocs..sp_sysmon_dcachestats:110
sybsystemprocs..sp_configure:1594
sybsystemprocs..sp_helpcache:81
sybsystemprocs..sp_countmetadata:175
sybsystemprocs..sp_monitor_getcfgval:29
sybsystemprocs..sp_helpserver:180
master..sysconfigures sybsystemprocs..sp_opt_querystats_main:217
sybsystemprocs..sp_configure:446
sybsystemprocs..sp_helpconfig:409
sybsystemprocs..sp_sysmon:744
sybsystemprocs..sp_cacheconfig:309
sybsystemprocs..sp_ijdbc_getxacoordinator:46
sybsystemprocs..sp_shmdumpdisp:856
sybsystemprocs..sp_opt_querystats_main:608
sybsystemprocs..sp_configure:1793
sybsystemprocs..sp_countmetadata:133
sybsystemprocs..sp_shmdumpsize:81
sybsystemprocs..sp_configure:1550
sybsystemprocs..sp_add_resource_limit:613
sybsystemprocs..sp_helpconfig:143
sybsystemprocs..sp_helpconfig:117
sybsystemprocs..sp_sysmon:886

DEPENDENCIES
READERS AND WRITERS
read 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_helptext  
read by proc sybsystemprocs..sp_countmetadata  
read by proc sybsystemprocs..sp_helpconfig  
read by proc sybsystemprocs..sp_shmdumpsize  
   called by proc sybsystemprocs..sp_shmdumpdisp  
      called by proc sybsystemprocs..sp_shmdumpconfig  
read by proc sybsystemprocs..sp_monitor_getcfgval  
   called by proc sybsystemprocs..sp_monitor_enable  
   called by proc sybsystemprocs..sp_monitor_verify_setup  
      called by proc sybsystemprocs..sp_monitor_disable  
      called by proc sybsystemprocs..sp_monitor_enable  
      called by proc sybsystemprocs..sp_monitor_list_montypes  
         called by proc sybsystemprocs..sp_monitor_list  
      called by proc sybsystemprocs..sp_monitor_procedure  
      called by proc sybsystemprocs..sp_monitor_archive  
         called by proc sybsystemprocs..sp_monitor_deadlock  
            called by proc sybsystemprocs..sp_monitor  
      called by proc sybsystemprocs..sp_monitor_event  
      called by proc sybsystemprocs..sp_monitor_connection  
      called by proc sybsystemprocs..sp_monitor_statement  
      called by proc sybsystemprocs..sp_monitor_deadlock  
   called by proc sybsystemprocs..sp_monitor_verify_cfgval  
      called by proc sybsystemprocs..sp_monitor_event  
      called by proc sybsystemprocs..sp_monitor_procedure  
      called by proc sybsystemprocs..sp_monitor_archive  
      called by proc sybsystemprocs..sp_monitor_list_montypes  
      called by proc sybsystemprocs..sp_monitor_connection  
      called by proc sybsystemprocs..sp_monitor_deadlock  
      called by proc sybsystemprocs..sp_monitor_statement  
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_shmdumpdisp  
read by proc sybsystemprocs..sp_addlogin  
read by proc sybsystemprocs..sp_sysmon_collect  
   called by proc sybsystemprocs..sp_sysmon  
read by proc sybsystemprocs..sp_downgrade  
read by proc sybsystemprocs..sp_aux_encr_verify_downgrade  
read by proc sybsystemprocs..sp_monitor_list_montypes  
read by proc sybsystemprocs..sp_sysmon  
read by proc sybsystemprocs..sp_opt_querystats_main  
   called by proc sybsystemprocs..sp_opt_querystats  
read by proc sybsystemprocs..sp_cacheconfig  
   called by proc sybsystemprocs..sp_do_poolconfig  
      called by proc sybsystemprocs..sp_poolconfig  
read by proc sybsystemprocs..sp_monitorconfig  
   called by proc sybsystemprocs..sp_sysmon_mdcache  
      called by proc sybsystemprocs..sp_sysmon_analyze  
         called by proc sybsystemprocs..sp_sysmon  
read by proc sybsystemprocs..sp_helpserver  
read by proc sybsystemprocs..sp_helpartition  
   called by proc sybsystemprocs..sp_help  
read by proc sybsystemprocs..sp_sysmon_dcachestats  
   called by proc sybsystemprocs..sp_sysmon_analyze_mda  
      called by proc sybsystemprocs..sp_sysmon  
read by proc sybsystemprocs..sp_modifylogin  
read by proc sybsystemprocs..sp_helpsort  
read by proc sybsystemprocs..sp_validateconfigname  
   called by proc sybsystemprocs..sp_helpconfig  
   called by proc sybsystemprocs..sp_countmetadata  
   called by proc sybsystemprocs..sp_monitorconfig  
read by proc sybsystemprocs..sp_helpcache  
read by proc sybsystemprocs..sp_sysmon_kernel  
   called by proc sybsystemprocs..sp_sysmon_analyze  
read by proc sybsystemprocs..sp_monitor_list  
read by proc sybsystemprocs..sp_index_space_est  
   called 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_do_poolconfig  
read by proc sybsystemprocs..sp_help  
read by proc sybsystemprocs..sp_add_resource_limit  
read by proc sybsystemprocs..sp_configure  
   called by proc sybsystemprocs..sp_configure  
   called by proc sybsystemprocs..sp_setlockpromote  
      called by proc sybsystemprocs..sp_setpglockpromote  
      called by proc sybsystemprocs..sp_setrowlockpromote  
read by proc sybsystemprocs..sp_maplogin  
read by proc sybsystemprocs..sp_ijdbc_getxacoordinator  
read by proc sybsystemprocs..sp_serverinfo  
   called by proc sybsystemprocs..sp_inform