DatabaseTableApplicationCreatedLinks
mastersyslanguages  31 Aug 14Joins Schema ColumnUsage Queries 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    create unique clustered index csyslanguages on syslanguages(-- 2 KB refcount: 2
14        langid
15    )
16    create unique index nc1syslanguages on syslanguages(-- 2 KB refcount: 13
17        name
18    )
19    create unique index nc2syslanguages on syslanguages(-- 2 KB refcount: 3
20        alias
21    )
22    
23    alter table syslanguages lock datarows
24    
25    Grant Select on syslanguages to public
26    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[name]master..spt_values[name]4 Rev FK

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

ALIASES USED for master..syslanguages
NO_ALIASlsyslanguages
1923

SCHEMA

COLUMN USAGE
langidsp_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_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:345
sybsystemprocs..sp_checkreswords:341

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