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

1     create table sysdatabases(-- 1 Rows, Data: 2 KB, Index: 6 KB
2         name sysname not null,
3         dbid smallint not null,
4         suid int not null,
5         status smallint not null,
6         version smallint not null,
7         logptr int not null,
8         crdate datetime not null,
9         dumptrdate datetime not null,
10        status2 smallint null,
11        audflags int null,
12        deftabaud int null,
13        defvwaud int null,
14        defpraud int null,
15        def_remote_type smallint null,
16        def_remote_loc varchar(349) null,
17        status3 int null,
18        status4 int null,
19        audflags2 varbinary(16) null,
20        spare tinyint null,
21        durability int null,
22        lobcomp_lvl tinyint null,
23        inrowlen smallint null,
24        dcompdefaultlevel tinyint null,
25        encrkeyid int null,
26        status5 int null
27    )
28    
29    
30    create unique clustered index cdatabases on sysdatabases(-- 2 KB refcount: 97
31        name
32    )
33    create unique index ncsysdatabases on sysdatabases(-- 2 KB refcount: 124
34        dbid
35    )
36    
37    alter table sysdatabases lock datarows
38    
39    Grant Select on sysdatabases to public
40    Grant Select on sysdatabases to sso_role
41    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[dbid]master..sysusages[dbid]12 Rev FK
[dbid]master..monRepScanners[DBID]4 Rev FK
[dbid]master..sysattributes[object]3 Rev FK
[encrkeyid]master..sysobjects[id]2 FK
[dbid]master..monRepSenders[DBID]2 Rev FK
[name]master..spt_values[name]2 Rev FK
[encrkeyid]sybsystemprocs..sysencryptkeys[id]1 Simple Join
[suid]sybsystemprocs..sysusers[suid]1 Simple Join
[dbid]master..monRepCoordinator[DBID]1 Rev FK
[dbid]master..monRepTruncationPoint[DBID]1 Rev FK
[name]master..sysattributes[object]1 Rev FK

Estimated Index Usage
sysdatabases.ncsysdatabases unique(dbid)124
sysdatabases.cdatabases unique clustered(name)97

ALIASES USED for master..sysdatabases
NO_ALIASabdd1dbssdsysdatabasessysdb
1591512641021281

SCHEMA

COLUMN USAGE
namesp_dboption  sp_dboption_flmode  sp_dropdevice  sp_addlogin  sp_addsegment  sp_addtype  sp_aux_encr_verify_downgrade  sp_checknames  sp_checkreswords  sp_chgattribute  sp_config_rep_agent  sp_dboption  sp_dboption_flmode  sp_dbrecovery_order  sp_dbremap  sp_ddlgen_database  sp_ddlgen_permissions  sp_defaultdb  sp_downgrade  sp_downgrade_esd  sp_downgrade_sysdams  sp_dropdevice  sp_droplockpromote  sp_droplockpromote_ptn  sp_dropsegment  sp_dropuser  sp_encryption  sp_extendsegment  sp_fixindex  sp_hadr_admin  sp_hadrvrfyargs  sp_help_rep_agent  sp_helpcache  sp_helpdb  sp_helprotect  sp_ijdbc_getcatalogs  sp_is_valid_user  sp_jdbc_getcatalogs  sp_jdbc_getcatalogs_cts  sp_logdevice  sp_lookup  sp_makesuspect_obj  sp_monitor_archive  sp_multdb_addtogroup  sp_multdb_bind  sp_multdb_removefromgroup  sp_multdb_show  sp_multdb_unbindall_db  sp_odbc_databases  sp_odbc_tables  sp_oledb_databases  sp_oledb_statistics  sp_oledb_tables  sp_oledb_views  sp_opt_querystats  sp_opt_querystats_main  sp_optimal_text_space  sp_plan_dbccdb  sp_post_xpload  sp_rebuild_text  sp_renamedb  sp_replication_path  sp_reptostandby  sp_setlockpromote  sp_setlockpromote_ptn  sp_setrepdbmode  sp_setsuspect_error  sp_spaceusage_object  sp_spaceusage_tranlog  sp_start_rep_agent  sp_stop_rep_agent  sp_sysmon_repagent  sp_tables 
dbidsp_dboption  sp_dboption_flmode  sp_dropdevice  sp_aux_encr_verify_downgrade  sp_bindcache  sp_cachestrategy  sp_changedbowner  sp_checknames  sp_chgattribute  sp_config_rep_agent  sp_dboption  sp_dboption_flmode  sp_dbrecovery_order  sp_ddlgen_database  sp_defaultloc  sp_downgrade  sp_downgrade_esd  sp_downgrade_sysdams  sp_downgrade_sysobjects  sp_dropdevice  sp_droplockpromote  sp_droplockpromote_ptn  sp_dropsegment  sp_dropuser  sp_drv_bcpmetadata  sp_encryption  sp_extendsegment  sp_hadr_admin  sp_help  sp_help_rep_agent  sp_helpdb  sp_helprotect  sp_logdevice  sp_logiosize  sp_makesuspect_obj  sp_merge_dup_inline_default  sp_odbc_databases  sp_plan_dbccdb  sp_renamedb  sp_replication_path  sp_restore_system_role  sp_setlockpromote  sp_setlockpromote_ptn  sp_setsuspect_error  sp_setsuspect_granularity  sp_spaceusage_tranlog_init  sp_spaceused  sp_spaceused_syslogs  sp_start_rep_agent  sp_stop_rep_agent  sp_sysmon_repagent 
suidsp_dboption  sp_dboption_flmode  sp_aux_encr_verify_downgrade  sp_changedbowner  sp_config_rep_agent  sp_dboption  sp_dboption_flmode  sp_ddlgen_permissions  sp_help_rep_agent  sp_helpdb  sp_is_valid_user  sp_logdevice  sp_lookup  sp_optimal_text_space  sp_replication_path  sp_reptostandby  sp_setrepdbmode  sp_start_rep_agent  sp_stop_rep_agent 
statussp_dboption  sp_addtype  sp_bindcache  sp_dboption  sp_downgrade  sp_downgrade_esd  sp_downgrade_sysobjects  sp_dropsegment  sp_encryption  sp_extendsegment  sp_helpdb  sp_is_valid_user  sp_logdevice  sp_merge_dup_inline_default  sp_monitor_archive  sp_renamedb  sp_restore_system_role  sp_transactions 
crdatesp_helpdb 
status2sp_dboption  sp_dboption  sp_downgrade  sp_downgrade_esd  sp_downgrade_sysobjects  sp_encryption  sp_helpcache  sp_helpdb  sp_is_valid_user  sp_restore_system_role  sp_setsuspect_granularity  sp_spaceusage_tranlog_init  sp_spaceused_syslogs 
def_remote_typesp_defaultloc 
def_remote_locsp_dbrecovery_order  sp_ddlgen_database  sp_defaultloc  sp_dropserver  sp_helpdb 
status3sp_dboption  sp_bindcache  sp_changedbowner  sp_config_rep_agent  sp_dboption  sp_dbrecovery_order  sp_ddlgen_database  sp_ddlgen_permissions  sp_defaultloc  sp_downgrade  sp_downgrade_esd  sp_downgrade_sysobjects  sp_dropsegment  sp_dropuser  sp_encryption  sp_extendsegment  sp_fixindex  sp_help_rep_agent  sp_helpcache  sp_helpdb  sp_logdevice  sp_logiosize  sp_monitor_archive  sp_multdb_addtogroup  sp_multdb_bind  sp_multdb_removefromgroup  sp_multdb_show  sp_multdb_unbindall_db  sp_plan_dbccdb  sp_post_xpload  sp_restore_system_role  sp_spaceused  sp_sysmon_repagent 
status4sp_dboption  sp_bindcache  sp_cachestrategy  sp_dboption  sp_ddlgen_database  sp_downgrade  sp_downgrade_esd  sp_downgrade_sysdams  sp_drv_bcpmetadata  sp_help  sp_helpdb  sp_logiosize 
durabilitysp_dboption  sp_changedbowner  sp_dboption  sp_ddlgen_database 
lobcomp_lvlsp_ddlgen_database  sp_downgrade  sp_helpdb 
inrowlensp_ddlgen_database  sp_downgrade  sp_helpdb 
encrkeyidsp_ddlgen_database  sp_encryption 
status5sp_dboption  sp_dboption  sp_helpdb 

QUERIES
Joined With Links
sybsystemprocs..syscolumns sybsystemprocs..sysobjects sybsystemprocs..sysusers sybsystemprocs..sp_aux_encr_verify_downgrade:294
master..spt_values sybsystemprocs..sp_checkreswords:336
sybsystemprocs..sp_checkreswords:332
sybsystemprocs..sysencryptkeys sybsystemprocs..sysobjects sybsystemprocs..sp_encryption:2265
master..sysdevices master..sysusages master..sp_dropdevice:124
master..sp_dropdevice:135
sybsystemprocs..sp_dropdevice:114
master..sp_dropdevice:99
sybsystemprocs..sp_plan_dbccdb:115
sybsystemprocs..sp_dropdevice:99
master..sp_dropdevice:114
sybsystemprocs..sp_dropdevice:124
sybsystemprocs..sp_dropdevice:135
sybsystemprocs..sp_ddlgen_database:354
master..sysusages sybsystemprocs..sp_helpdb:900
sybsystemprocs..sp_odbc_databases:36
master..sysattributes master..sp_dropdevice:160
sybsystemprocs..sp_dropdevice:160
sybsystemprocs..sp_dbrecovery_order:235
master..monRepScanners sybsystemprocs..sp_help_rep_agent:661
sybsystemprocs..sp_help_rep_agent:717
sybsystemprocs..sp_help_rep_agent:542
master..monRepSenders sybsystemprocs..sp_help_rep_agent:567
sybsystemprocs..sp_help_rep_agent:984
master..sysobjects sybsystemprocs..sp_ddlgen_database:878
master..monRepCoordinator sybsystemprocs..sp_help_rep_agent:513
master..monRepTruncationPoint sybsystemprocs..sp_help_rep_agent:605
master..monRepSenders master..monRepScanners sybsystemprocs..sp_help_rep_agent:320
master..sysobjects master..sysusers sybsystemprocs..sp_ddlgen_database:887

COLUMN WRITES detailed
ColumnWritten From
name    sp_renamedb.@newname  
suid    syslogins.suid   sp_gen_login_id.@?  
status    sysdatabases.status   spt_values.number   sp_dboption.@?   sp_helpsort.@?   sp_dboption.@?  
status2    spt_values.number   sysdatabases.status2   sp_helpsort.@?   sp_setsuspect_granularity.@?  
def_remote_type    spt_values.number   sp_defaultloc.@?   sp_helpsort.@?  
def_remote_loc    sp_defaultloc.@defaultloc   sp_defaultloc.@?  
status3    spt_values.number   sysdatabases.status3   sp_helpsort.@?  
status4    spt_values.number   sysdatabases.status4   sp_helpsort.@?  
status5    sysdatabases.status5   spt_values.number   sp_helpsort.@?  

DATA PROPAGATION detailed
ColumnWritten To
dbidsysattributes.object   °.object_info1   °.object_info3   °.char_value   sysremotelogins.remoteserverid   sysservers.srvid   sysattributes.object   °.object_info1   °.object_info3   °.int_value  
°.char_value   sysqueryplans.gid   sp_dropdevice_rset_001.device sp_checknames_rset_006.remoteserverid sp_checknames_rset_007.srvid sp_checknames_rset_008.srvid sp_checknames_rset_013.name sp_dbrecovery_order_rset_001.Database Name °.Database id sp_displayroles_rset_001.Role Name
sp_displayroles_rset_002.Role Name °.Grantee sp_displayroles_rset_003.Role Name sp_displayroles_rset_004.Role Name sp_downgrade_rset_001.dbid °.name sp_downgrade_rset_007.pll_ntas_in_alr sp_dropdevice_rset_001.device sp_find_qplan_rset_001.gid sp_forceonline_object_rset_001.Object
°.status sp_forceonline_object_rset_002.Object °.status sp_forceonline_page_rset_001.status sp_forceonline_page_rset_002.status sp_hadr_admin_rset_007.Number of user connections in chained mode sp_hadr_admin_rset_008.Number of user connections in unchained mode sp_help_qplan_rset_001.hashkey sp_help_qplan_rset_004.query_plan sp_helpdb_rset_003.remote location
sp_listsuspect_object_rset_001.Object °.Access sp_listsuspect_page_rset_001.Object °.Access sp_makesuspect_obj_rset_001.Obj °.Indid °.LogType °.PageType °.ErrType °.Delay
°.TotalNum sp_makesuspect_obj_rset_002.Obj °.Indid °.LogType °.PageType °.ErrType °.Delay °.TotalNum sp_makesuspect_obj_rset_003.Obj °.Indid
°.LogType °.PageType °.ErrType °.Delay °.TotalNum sp_memlog_rset_001.dumps_per_file sp_passwordpolicy_rset_001.message sp_passwordpolicy_rset_002.value °.message sp_passwordpolicy_rset_003.value
sp_passwordpolicy_rset_004.Policy_option sp_rjs_retrieve_rset_001.host_name sp_setsuspect_granularity_rset_001.Online mode sp_show_metrics_rset_001.Group ID sp_show_query_tuning_rset_001.Group ID sp_ssladmin_rset_001.certificate_path sp_ssladmin_rset_002.Cipher Suite Name °.Preference
def_remote_locsp_helpdb_rset_001.sqlbNoName73 sp_helpdb_rset_002.template_database
namesp_dropdevice_rset_001.database_name sp_dropdevice_rset_002.database_name sp_dropdevice_rset_003.sqlbNoName2 sp_checkreswords_rset_006.sqlbNoName47 sp_config_rep_agent_rset_003.List of Options sp_downgrade_esd_rset_001.check these databases sp_downgrade_rset_001.dbid °.name sp_downgrade_rset_002.Investigate these databases: sp_downgrade_rset_003.Investigate these databases:
sp_downgrade_rset_004.check these databases sp_downgrade_rset_005.check these databases sp_downgrade_rset_006.check these databases sp_downgrade_rset_007.pll_ntas_in_log sp_dropdevice_rset_001.database_name sp_dropdevice_rset_002.database_name sp_dropdevice_rset_003.sqlbNoName66 sp_jdbc_getcatalogs_rset_001.TABLE_CAT sp_odbc_databases_rset_001.database_name sp_odbc_tables_rset_003.TABLE_CAT
sp_oledb_databases_rset_001.CATALOG_NAME sp_oledb_databases_rset_002.CATALOG_NAME sp_oledb_statistics_rset_001.TABLE_CATALOG sp_oledb_tables_rset_001.TABLE_CATALOG sp_oledb_tables_rset_002.TABLE_CATALOG sp_oledb_views_rset_001.TABLE_CATALOG sp_tables_rset_003.table_qualifier
statussysdatabases.status  
status2sysdatabases.status2  
status3sysdatabases.status3  
status4sysdatabases.status4  
status5sysdatabases.status5  

DEPENDENCIES
READERS AND WRITERS
read by proc sybsystemprocs..sp_oledb_tables  
read by proc sybsystemprocs..sp_chgattribute  
read by proc sybsystemprocs..sp_encryption  
   called by proc sybsystemprocs..sp_downgrade  
read_written by proc sybsystemprocs..sp_changedbowner  
read by proc sybsystemprocs..sp_dropserver  
   called by proc sybsystemprocs..sp_hadr_admin  
      called by proc sybsystemprocs..sp_hadr_update  
read by proc sybsystemprocs..sp_help  
read by proc sybsystemprocs..sp_ddlgen_database  
read by proc sybsystemprocs..sp_setlockpromote  
   called by proc sybsystemprocs..sp_setrowlockpromote  
   called by proc sybsystemprocs..sp_setpglockpromote  
read by proc sybsystemprocs..sp_addsegment  
read by proc sybsystemprocs..sp_helpcache  
read by proc sybsystemprocs..sp_oledb_statistics  
read by proc sybsystemprocs..sp_dbrecovery_order  
read by proc sybsystemprocs..sp_multdb_show  
   called by proc sybsystemprocs..sp_tempdb  
read by proc sybsystemprocs..sp_merge_dup_inline_default  
read by proc sybsystemprocs..sp_defaultdb  
   called by proc sybsystemprocs..sp_modifylogin  
read by proc sybsystemprocs..sp_reptostandby  
read by proc sybsystemprocs..sp_multdb_unbindall_db  
   called by proc sybsystemprocs..sp_tempdb  
read by proc sybsystemprocs..sp_checknames  
read by proc master..sp_dropdevice  
read by proc sybsystemprocs..sp_addlogin  
read by proc sybsystemprocs..sp_spaceused  
read_written by proc sybsystemprocs..sp_dboption  
read by proc sybsystemprocs..sp_opt_querystats  
read by proc sybsystemprocs..sp_stop_rep_agent  
read by proc sybsystemprocs..sp_ddlgen_permissions  
read by proc sybsystemprocs..sp_downgrade_esd  
read by proc sybsystemprocs..sp_opt_querystats_main  
   called by proc sybsystemprocs..sp_opt_querystats  
read by proc sybsystemprocs..sp_dbremap  
read by proc sybsystemprocs..sp_transactions  
read by proc sybsystemprocs..sp_config_rep_agent  
read by proc sybsystemprocs..sp_start_rep_agent  
read by proc sybsystemprocs..sp_restore_system_role  
read by proc sybsystemprocs..sp_jdbc_getcatalogs  
read by proc sybsystemprocs..sp_droplockpromote  
   called by proc sybsystemprocs..sp_dropglockpromote  
   called by proc sybsystemprocs..sp_droprowlockpromote  
read by proc sybsystemprocs..sp_dboption_flmode  
   called by proc sybsystemprocs..sp_dboption  
read by proc sybsystemprocs..sp_checkreswords  
read by proc sybsystemprocs..sp_makesuspect_obj  
read by proc sybsystemprocs..sp_optimal_text_space  
   called by proc sybsystemprocs..sp_chgattribute  
read by proc sybsystemprocs..sp_plan_dbccdb  
read by proc sybsystemprocs..sp_dropsegment  
read by proc sybsystemprocs..sp_addtype  
read by proc sybsystemprocs..sp_spaceusage_tranlog_init  
   called by proc sybsystemprocs..sp_spaceusage_tranlog  
      called by proc sybsystemprocs..sp_spaceusage  
read by proc sybsystemprocs..sp_oledb_views  
read by proc master..sp_dboption_flmode  
   called by proc master..sp_dboption  
read by proc sybsystemprocs..sp_setsuspect_error  
read by proc sybsystemprocs..sp_multdb_removefromgroup  
   called by proc sybsystemprocs..sp_tempdb  
read by proc sybsystemprocs..sp_ijdbc_getcatalogs  
read by proc sybsystemprocs..sp_oledb_databases  
read by proc sybsystemprocs..sp_multdb_bind  
   called by proc sybsystemprocs..sp_tempdb  
read by proc sybsystemprocs..sp_helpdb  
read by proc sybsystemprocs..sp_helprotect  
read by proc sybsystemprocs..sp_fixindex  
read by proc sybsystemprocs..sp_spaceusage_object  
   called by proc sybsystemprocs..sp_spaceusage  
read by proc sybsystemprocs..sp_dropdevice  
read by proc sybsystemprocs..sp_help_rep_agent  
read by proc sybsystemprocs..sp_downgrade_sysdams  
   called by proc sybsystemprocs..sp_downgrade_esd  
   called by proc sybsystemprocs..sp_downgrade  
read_written by proc master..sp_dboption  
read by proc sybsystemprocs..sp_post_xpload  
read_written by proc sybsystemprocs..sp_defaultloc  
read by proc sybsystemprocs..sp_jdbc_getcatalogs_cts  
read by proc sybsystemprocs..sp_aux_encr_verify_downgrade  
read by proc sybsystemprocs..sp_sysmon_repagent  
   called by proc sybsystemprocs..sp_sysmon_analyze  
      called by proc sybsystemprocs..sp_sysmon  
read_written by proc sybsystemprocs..sp_renamedb  
read by proc sybsystemprocs..sp_monitor_archive  
   called by proc sybsystemprocs..sp_monitor_deadlock  
      called by proc sybsystemprocs..sp_monitor  
read by proc sybsystemprocs..sp_bindcache  
   called by proc sybsystemprocs..sp_unbindcache  
read by proc sybsystemprocs..sp_setlockpromote_ptn  
   called by proc sybsystemprocs..sp_setpglockpromote_ptn  
   called by proc sybsystemprocs..sp_setrowlockpromote_ptn  
read by proc sybsystemprocs..sp_hadr_admin  
read by proc sybsystemprocs..sp_replication_path  
read by proc sybsystemprocs..sp_spaceusage_tranlog  
read by proc sybsystemprocs..sp_logdevice  
read by proc sybsystemprocs..sp_spaceused_syslogs  
   called by proc sybsystemprocs..sp_helpsegment  
   called by proc sybsystemprocs..sp_spaceused  
read by proc sybsystemprocs..sp_downgrade_sysobjects  
   called by proc sybsystemprocs..sp_downgrade  
read by proc sybsystemprocs..sp_lookup  
read by proc sybsystemprocs..sp_odbc_databases  
read by proc sybsystemprocs..sp_multdb_addtogroup  
   called by proc sybsystemprocs..sp_tempdb  
read by proc sybsystemprocs..sp_tables  
read by proc sybsystemprocs..sp_droplockpromote_ptn  
   called by proc sybsystemprocs..sp_droprowlockpromote_ptn  
   called by proc sybsystemprocs..sp_dropglockpromote_ptn  
read by proc sybsystemprocs..sp_hadrvrfyargs  
   called by proc sybsystemprocs..sp_hadr_admin  
read by proc sybsystemprocs..sp_dropuser  
read by proc sybsystemprocs..sp_setrepdbmode  
read by proc sybsystemprocs..sp_rebuild_text  
read by proc sybsystemprocs..sp_odbc_tables  
read by proc sybsystemprocs..sp_cachestrategy  
read by proc sybsystemprocs..sp_is_valid_user  
   called by proc sybsystemprocs..sp_plan_dbccdb  
read by proc sybsystemprocs..sp_drv_bcpmetadata  
read_written by proc sybsystemprocs..sp_downgrade  
written by proc sybsystemprocs..sp_setsuspect_granularity  
read by proc sybsystemprocs..sp_logiosize  
read by proc sybsystemprocs..sp_extendsegment