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

1     create table syslanguages(-- 0 Rows, Data: 2 KB, Index: 8 KB
2         langid smallint not null,
3         dateformat char(3) not null,
4         datefirst tinyint not null,
5         upgrade int not null,
6         name varchar(30) not null,
7         alias varchar(30) null,
8         months varchar(251) not null,
9         shortmonths varchar(119) not null,
10        days varchar(216) not null
11    )
12    
13    
14    create unique clustered index csyslanguages on syslanguages(-- 2 KB refcount: 3
15        langid
16    )
17    create unique index nc1syslanguages on syslanguages(-- 2 KB refcount: 15
18        name
19    )
20    create unique index nc2syslanguages on syslanguages(-- 2 KB refcount: 3
21        alias
22    )
23    
24    alter table syslanguages lock datarows
25    
26    Grant Select on syslanguages to public
27    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[name]master..spt_values[name]2 Rev FK

Estimated Index Usage
syslanguages.nc1syslanguages unique(name)15
syslanguages.csyslanguages unique clustered(langid)3
syslanguages.nc2syslanguages unique(alias)3

ALIASES USED for master..syslanguages
NO_ALIASlsyslanguages
2223

SCHEMA

COLUMN USAGE
langidsp_configure  sp_getmessage  sp_addlanguage  sp_addmessage  sp_configure  sp_droplanguage  sp_dropmessage  sp_getmessage  sp_helplanguage  sp_inst15015msg_oth_mesg 
dateformatsp_addlanguage  sp_helplanguage 
datefirstsp_addlanguage  sp_helplanguage 
upgradesp_addlanguage  sp_downgrade  sp_helplanguage 
namesp_getmessage  sp_validlang  sp_addlanguage  sp_addmessage  sp_checkreswords  sp_droplanguage  sp_dropmessage  sp_getmessage  sp_helplanguage  sp_inst15015msg_oth_mesg  sp_setlangalias  sp_validlang 
aliassp_addlanguage  sp_helplanguage  sp_setlangalias  sp_validaltlang 
monthssp_addlanguage  sp_helplanguage 
shortmonthssp_addlanguage  sp_helplanguage 
dayssp_addlanguage  sp_helplanguage 

QUERIES
Joined With Links
master..spt_values sybsystemprocs..sp_checkreswords:344
sybsystemprocs..sp_checkreswords:348

COLUMN WRITES detailed
ColumnWritten From
langid    syslanguages.langid   sp_addlanguage.@?  
dateformat    sp_addlanguage.@datefmt  
datefirst    sp_addlanguage.@datefirst  
upgrade    sp_addlanguage.@?   sp_downgrade.@?  
name    sp_addlanguage.@language  
alias    sp_addlanguage.@alias   sp_setlangalias.@alias   sp_addlanguage.@language  
months    sp_addlanguage.@months  
shortmonths    sp_addlanguage.@shortmons  
days    sp_addlanguage.@days  

DATA PROPAGATION detailed
ColumnWritten To
langidsyslanguages.langid   sysmessages.langid   sysusermessages.langid  
namesp_checkreswords_rset_005.Reserved Word Datatype Names

DEPENDENCIES
READERS AND WRITERS
read by proc sybsystemprocs..sp_getmessage  
   called by proc sybsystemprocs..sp_helpconstraint  
   called by proc sybsystemprocs..sp_addsegment  
   called by proc sybsystemprocs..sp_spaceusage_tranlog_genoutput  
      called by proc sybsystemprocs..sp_spaceusage_tranlog  
         called by proc sybsystemprocs..sp_spaceusage  
   called by proc sybsystemprocs..sp_jdbc_tables  
   called by proc sybsystemprocs..sp_aux_encr_verify_downgrade  
   called by proc sybsystemprocs..sp_bindefault  
   called by proc sybsystemprocs..sp_chgattribute  
   called by proc sybsystemprocs..sp_displaylevel  
   called by proc sybsystemprocs..sp_placeobject  
   called by proc sybsystemprocs..sp_displayroles  
   called by proc sybsystemprocs..sp_ijdbc_getversioncolumns  
   called by proc sybsystemprocs..sp_jdbc_getindexinfo  
   called by proc sybsystemprocs..sp_encryption  
      called by proc sybsystemprocs..sp_downgrade  
   called by proc sybsystemprocs..sp_addumpdevice  
   called by proc sybsystemprocs..sp_setreplicate  
   called by proc sybsystemprocs..sp_dropthreshold  
   called by proc sybsystemprocs..sp_depends_cols  
      called by proc sybsystemprocs..sp_depends  
   called by proc sybsystemprocs..sp_ijdbc_columns  
   called by proc sybsystemprocs..sp_ddlgen_help  
   called by proc sybsystemprocs..sp_dumpoptimize  
   called by proc sybsystemprocs..sp_helpconfig  
      called by proc sybsystemprocs..sp_helpconfig_gen_estimates_cpi  
         called by proc sybsystemprocs..sp_helpconfig_est_compinfo_poolsize  
   called by proc sybsystemprocs..sp_optgoal  
   called by proc sybsystemprocs..sp_bindrule  
   called by proc sybsystemprocs..sp_showtext_usage  
      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  
      called by proc sybsystemprocs..sp_showtext  
   called by proc sybsystemprocs..sp_spaceusage_showhelp_report  
      called by proc sybsystemprocs..sp_spaceusage_showhelp_all  
         called by proc sybsystemprocs..sp_spaceusage_showhelp  
            called by proc sybsystemprocs..sp_spaceusage  
   called by proc sybsystemprocs..sp_spaceusage_showhelp_archive  
      called by proc sybsystemprocs..sp_spaceusage_showhelp_all  
   called by proc sybsystemprocs..sp_helpgroup  
      called by proc sybsystemprocs..sp_helpuser  
   called by proc sybsystemprocs..sp_dropdevice  
   called by proc sybsystemprocs..sp_droplockpromote  
      called by proc sybsystemprocs..sp_droprowlockpromote  
      called by proc sybsystemprocs..sp_dropglockpromote  
   called by proc sybsystemprocs..sp_dropserver  
      called by proc sybsystemprocs..sp_hadr_admin  
         called by proc sybsystemprocs..sp_hadr_update  
   called by proc sybsystemprocs..sp_adduser  
   called by proc sybsystemprocs..sp_helptrigger  
   called by proc sybsystemprocs..sp_helprotect  
   called by proc sybsystemprocs..sp_check_remote_tempdb  
      called by proc sybsystemprocs..sp_restore_system_role  
      called by proc sybsystemprocs..sp_ddlgen_permissions  
   called by proc sybsystemprocs..sp_ijdbc_getbestrowidentifier  
   called by proc sybsystemprocs..sp_renamedb  
   called by proc sybsystemprocs..sp_errorlog_showhelp  
      called by proc sybsystemprocs..sp_errorlog  
   called by proc sybsystemprocs..sp_helpuser  
   called by proc sybsystemprocs..sp_spaceusage_object_genoutput  
      called by proc sybsystemprocs..sp_spaceusage_object  
         called by proc sybsystemprocs..sp_spaceusage  
   called by proc sybsystemprocs..sp_forceonline_object  
   called by proc sybsystemprocs..sp_setrepdbmode  
   called by proc sybsystemprocs..sp_showpsexe  
   called by proc sybsystemprocs..sp_indsuspect  
   called by proc sybsystemprocs..sp_modifylogin  
   called by proc sybsystemprocs..sp_droplanguage  
   called by proc sybsystemprocs..sp_helpcomputedcolumn  
      called by proc sybsystemprocs..sp_help  
      called by proc sybsystemprocs..sp_helpindex  
         called by proc sybsystemprocs..sp_help  
   called by proc sybsystemprocs..sp_helpconfig_usage  
      called by proc sybsystemprocs..sp_helpconfig  
   called by proc sybsystemprocs..sp_jdbc_getbestrowidentifier  
   called by proc sybsystemprocs..sp_defaultloc  
   called by proc sybsystemprocs..sp_spaceusage_showhelp  
   called 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  
      called by proc sybsystemprocs..sp_downgrade_esd  
   called by proc sybsystemprocs..sp_spaceusage_object_archdata  
      called by proc sybsystemprocs..sp_spaceusage_object  
   called by proc sybsystemprocs..sp_ijdbc_stored_procedures  
   called by proc sybsystemprocs..sp_downgrade_esd  
   called by proc sybsystemprocs..sp_setsuspect_threshold  
   called by proc sybsystemprocs..sp_jdbc_columns  
   called by proc sybsystemprocs..sp_sproc_columns  
   called by proc sybsystemprocs..sp_defaultlanguage  
      called by proc sybsystemprocs..sp_modifylogin  
   called by proc sybsystemprocs..sp_changedbowner  
   called by proc sybsystemprocs..sp_drop_time_range  
   called by proc sybsystemprocs..sp_passwordpolicy  
      called by proc sybsystemprocs..sp_downgrade  
   called by proc sybsystemprocs..sp_locklogin  
      called by proc sybsystemprocs..sp_addlogin  
   called by proc sybsystemprocs..sp_defaultdb  
      called by proc sybsystemprocs..sp_modifylogin  
   called by proc sybsystemprocs..sp_fkeys  
   called by proc sybsystemprocs..sp_listsuspect_db  
   called by proc sybsystemprocs..sp_bindcache  
      called by proc sybsystemprocs..sp_unbindcache  
   called by proc sybsystemprocs..sp_monitor_report_usage  
   called by proc sybsystemprocs..sp_mon_archive_data  
      called by proc sybsystemprocs..sp_mon_archive_monTable  
         called by proc sybsystemprocs..sp_mon_archive_deadlock  
   called by proc sybsystemprocs..sp_addserver  
   called by proc sybsystemprocs..sp_ijdbc_getcolumnprivileges  
   called by proc sybsystemprocs..sp_helpdevice  
   called by proc sybsystemprocs..sp_helplog  
   called by proc sybsystemprocs..sp_addtabledef  
   called by proc sybsystemprocs..sp_showtext_output  
   called by proc sybsystemprocs..sp_start_rep_agent  
   called by proc sybsystemprocs..sp_dboption  
   called by proc sybsystemprocs..sp_dropexternlogin  
   called by proc sybsystemprocs..sp_help_query_tuning  
      called by proc sybsystemprocs..sp_query_tuning  
   called by proc sybsystemprocs..sp_dropkey  
   called by proc sybsystemprocs..sp_jdbc_stored_procedures  
   called by proc sybsystemprocs..sp_setrepproc  
   called by proc sybsystemprocs..sp_helpsort  
   called by proc sybsystemprocs..sp_monitor_enable_usage  
   called by proc sybsystemprocs..sp_monitor_disable_usage  
   called by proc sybsystemprocs..sp_cmp_all_qplans  
   called by proc sybsystemprocs..sp_foreignkey  
   called by proc sybsystemprocs..sp_monitor_deadlock_count_by  
      called by proc sybsystemprocs..sp_monitor_deadlock  
         called by proc sybsystemprocs..sp_monitor  
   called by proc sybsystemprocs..sp_serverinfo  
      called by proc sybsystemprocs..sp_inform  
   called by proc sybsystemprocs..sp_forceonline_page  
      called by proc sybsystemprocs..sp_forceonline_db  
   called by proc sybsystemprocs..sp_shmdumpconfig  
   called by proc sybsystemprocs..sp_dropgroup  
   called by proc sybsystemprocs..sp_add_time_range  
   called by proc sybsystemprocs..sp_helpindex  
   called by proc sybsystemprocs..sp_merge_dup_inline_default  
   called by proc sybsystemprocs..sp_serveroption  
   called by proc sybsystemprocs..sp_primarykey  
   called by proc sybsystemprocs..sp_setlangalias  
   called by proc sybsystemprocs..sp_help  
   called by proc sybsystemprocs..sp_addmessage  
   called by proc sybsystemprocs..sp_setsuspect_granularity  
   called by proc sybsystemprocs..sp_reptostandby  
   called by proc sybsystemprocs..sp_tab_suspectptn  
   called by proc sybsystemprocs..sp_drop_resource_limit  
   called by proc sybsystemprocs..sp_dboption_flmode  
      called by proc sybsystemprocs..sp_dboption  
   called by proc sybsystemprocs..sp_revokelogin  
   called by proc sybsystemprocs..sp_monitor_procstack_usage  
   called by proc sybsystemprocs..sp_objectsegment  
   called by proc sybsystemprocs..sp_ldapadmin  
   called by proc sybsystemprocs..sp_help_qpgroup  
   called by proc sybsystemprocs..sp_logging_rate  
   called by proc sybsystemprocs..sp_maplogin  
   called by proc sybsystemprocs..sp_spaceusage_showhelp_display  
      called by proc sybsystemprocs..sp_spaceusage_showhelp_all  
   called by proc sybsystemprocs..sp_dropmessage  
   called by proc sybsystemprocs..sp_familylock  
   called by proc sybsystemprocs..sp_countmetadata  
   called by proc sybsystemprocs..sp_modifythreshold  
   called by proc sybsystemprocs..sp_unbindefault  
   called by proc sybsystemprocs..sp_ijdbc_getindexinfo  
   called by proc sybsystemprocs..sp_extendsegment  
   called by proc sybsystemprocs..sp_oledb_getprocedurecolumns  
   called by proc sybsystemprocs..sp_helpserver  
   called by proc sybsystemprocs..sp_add_resource_limit  
   called by proc sybsystemprocs..sp_helpdefrag  
   called by proc sybsystemprocs..sp_helpsegment  
   called by proc sybsystemprocs..sp_forceonline_db  
   called by proc sybsystemprocs..sp_spaceusage_object_populate  
      called by proc sybsystemprocs..sp_spaceusage_object  
   called by proc sybsystemprocs..sp_listsuspect_page  
   called by proc sybsystemprocs..sp_plan_dbccdb  
   called by proc sybsystemprocs..sp_validateconfigname  
      called by proc sybsystemprocs..sp_countmetadata  
      called 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  
      called by proc sybsystemprocs..sp_helpconfig  
   called by proc sybsystemprocs..sp_remoteoption  
   called by proc sybsystemprocs..sp_setsuspect_error  
   called by proc sybsystemprocs..sp_droptype  
   called by proc sybsystemprocs..sp_password  
      called by proc sybsystemprocs..sp_addlogin  
   called by proc sybsystemprocs..sp_helpjava  
   called by proc sybsystemprocs..sp_helpartition  
      called by proc sybsystemprocs..sp_help  
   called by proc sybsystemprocs..sp_setrepdefmode  
   called by proc sybsystemprocs..sp_jdbc_getversioncolumns  
   called by proc sybsystemprocs..sp_monitor_deadlock_usage  
      called by proc sybsystemprocs..sp_monitor_deadlock  
   called by proc sybsystemprocs..sp_helpdb  
   called by proc sybsystemprocs..sp_monitor_list_montypes  
      called by proc sybsystemprocs..sp_monitor_list  
   called by proc sybsystemprocs..sp_dropuser  
   called by proc sybsystemprocs..sp_droplockpromote_ptn  
      called by proc sybsystemprocs..sp_droprowlockpromote_ptn  
      called by proc sybsystemprocs..sp_dropglockpromote_ptn  
   called by proc sybsystemprocs..sp_autoconnect  
   called by proc sybsystemprocs..sp_displaylogin  
   called by proc sybsystemprocs..sp_stop_rep_agent  
   called by proc sybsystemprocs..sp_spaceusage_tranlog_archdata  
      called by proc sybsystemprocs..sp_spaceusage_tranlog  
   called by proc sybsystemprocs..sp_addexternlogin  
   called by proc sybsystemprocs..sp_logdevice  
   called by proc sybsystemprocs..sp_addgroup  
   called by proc sybsystemprocs..sp_rename  
   called by proc sybsystemprocs..sp_helplanguage  
   called by proc sybsystemprocs..sp_addtype  
   called by proc sybsystemprocs..sp_restore_system_role  
   called by proc sybsystemprocs..sp_hadr_admin  
   called by proc sybsystemprocs..sp_setlockpromote  
   called by proc sybsystemprocs..sp_helpremotelogin  
   called by proc sybsystemprocs..sp_monitor_list  
   called by proc sybsystemprocs..sp_commonkey  
   called by proc sybsystemprocs..sp_monitor_help  
   called by proc sybsystemprocs..sp_spaceusage_runcmd  
      called by proc sybsystemprocs..sp_spaceusage  
   called by proc sybsystemprocs..sp_ijdbc_tables  
   called by proc sybsystemprocs..sp_dropsegment  
   called by proc sybsystemprocs..sp_logiosize  
   called by proc sybsystemprocs..sp_grantlogin  
   called by proc sybsystemprocs..sp_deviceattr  
   called by proc sybsystemprocs..sp_ijdbc_primarykey  
   called by proc sybsystemprocs..sp_addthreshold  
   called by proc sybsystemprocs..sp_monitor_connection_usage  
   called by proc sybsystemprocs..sp_odbc_getprocedurecolumns  
   called by proc sybsystemprocs..sp_lock  
   called by proc sybsystemprocs..sp_depends  
   called by proc sybsystemprocs..sp_helpkey  
      called by proc sybsystemprocs..sp_help  
   called by proc sybsystemprocs..sp_help_metrics  
      called by proc sybsystemprocs..sp_metrics  
   called by proc sybsystemprocs..sp_unbindmsg  
   called by proc sybsystemprocs..sp_jdbc_primarykey  
   called by proc sybsystemprocs..sp_monitorconfig  
   called by proc sybsystemprocs..sp_downgrade  
   called by proc sybsystemprocs..sp_volchanged  
   called by proc sybsystemprocs..sp_help_rep_agent  
   called by proc sybsystemprocs..sp_addlogin  
   called by proc sybsystemprocs..sp_changegroup  
   called by proc sybsystemprocs..sp_clearstats  
   called by proc sybsystemprocs..sp_compatmode  
   called by proc sybsystemprocs..sp_monitor_archive  
      called by proc sybsystemprocs..sp_monitor_deadlock  
   called by proc sybsystemprocs..sp_addremotelogin  
   called by proc sybsystemprocs..sp_shmdumpdisp  
      called by proc sybsystemprocs..sp_shmdumpconfig  
   called by proc sybsystemprocs..sp_recompile  
   called by proc sybsystemprocs..sp_addlanguage  
   called by proc sybsystemprocs..sp_ijdbc_fkeys  
      called by proc sybsystemprocs..sp_ijdbc_getcrossreferences  
      called by proc sybsystemprocs..sp_ijdbc_importkey  
      called by proc sybsystemprocs..sp_ijdbc_exportkey  
   called by proc sybsystemprocs..sp_role  
      called by proc master..mon_authorize_non_sa (1)  
   called by proc sybsystemprocs..sp_setreptable  
   called by proc sybsystemprocs..sp_tempdb  
   called by proc sybsystemprocs..sp_setrepcol  
   called by proc sybsystemprocs..sp_odbc_fkeys  
   called by proc sybsystemprocs..sp_jdbc_fkeys  
      called by proc sybsystemprocs..sp_jdbc_importkey  
      called by proc sybsystemprocs..sp_jdbc_getcrossreferences  
      called by proc sybsystemprocs..sp_jdbc_exportkey  
   called by proc sybsystemprocs..sp_monitor_disable  
   called by proc sybsystemprocs..sp_logintrigger  
      called by proc sybsystemprocs..sp_modifylogin  
   called by proc sybsystemprocs..sp_addalias  
   called by proc sybsystemprocs..sp_config_rep_agent  
   called by proc sybsystemprocs..sp_ijdbc_getprocedurecolumns  
   called by proc sybsystemprocs..sp_setlockpromote_ptn  
      called by proc sybsystemprocs..sp_setpglockpromote_ptn  
      called by proc sybsystemprocs..sp_setrowlockpromote_ptn  
   called by proc sybsystemprocs..sp_dropalias  
   called by proc sybsystemprocs..sp_fixindex  
   called by proc sybsystemprocs..sp_dropremotelogin  
   called by proc sybsystemprocs..sp_bindmsg  
   called by proc sybsystemprocs..sp_monitor_archive_usage  
   called by proc sybsystemprocs..sp_unbindrule  
   called by proc sybsystemprocs..sp_monitor_procstack  
   called by proc sybsystemprocs..sp_cmp_qplans  
      called by proc sybsystemprocs..sp_copy_qplan  
         called by proc sybsystemprocs..sp_copy_all_qplans  
   called by proc sybsystemprocs..sp_jdbc_getfunctioncolumns  
   called by proc sybsystemprocs..sp_jdbc_getprocedurecolumns  
   called by proc sybsystemprocs..sp_errorlog  
written by proc sybsystemprocs..sp_setlangalias  
read by proc sybsystemprocs..sp_addmessage  
read_written by proc sybsystemprocs..sp_droplanguage  
read by proc sybsystemprocs..sp_validaltlang  
   called by proc sybsystemprocs..sp_addlanguage  
   called by proc sybsystemprocs..sp_setlangalias  
read by proc sybsystemprocs..sp_configure  
read by proc master..sp_configure  
   called by proc master..sp_configure  
read by proc sybsystemprocs..sp_inst15015msg_oth_mesg  
   called by proc sybsystemprocs..sp_inst15015msg_all_oth_mesgs  
      called by proc sybsystemprocs..sp_inst15015msg  
         called by proc sybsystemprocs..sp_downgrade  
read by proc sybsystemprocs..sp_helplanguage  
read by proc sybsystemprocs..sp_validlang  
   called by proc sybsystemprocs..sp_getmessage  
   called by proc sybsystemprocs..sp_setlangalias  
   called by proc sybsystemprocs..sp_droplanguage  
   called by proc sybsystemprocs..sp_dropmessage  
   called by proc sybsystemprocs..sp_addmessage  
   called by proc sybsystemprocs..sp_defaultlanguage  
   called by proc sybsystemprocs..sp_addlanguage  
   called by proc sybsystemprocs..sp_addlogin  
read by proc master..sp_getmessage  
   called by proc master..sp_dboption  
   called by proc master..sp_dboption_flmode  
      called by proc master..sp_dboption  
   called by proc master..sp_check_remote_tempdb  
   called by proc master..sp_configure  
   called by proc master..sp_dropdevice  
   called by proc master..sp_prtsybsysmsgs  
read by proc sybsystemprocs..sp_dropmessage  
read_written by proc sybsystemprocs..sp_addlanguage  
read by proc sybsystemprocs..sp_checkreswords  
read by proc master..sp_validlang  
   called by proc master..sp_getmessage  
written by proc sybsystemprocs..sp_downgrade