DatabaseTableApplicationCreatedLinks
mastersystypes  31 Aug 14Joins Schema ColumnUsage Queries Dependencies

1     create table systypes(-- 49 Rows, Data: 4 KB, Index: 16 KB
2         uid int not null,
3         usertype smallint not null,
4         variable bit not null,
5         allownulls bit not null,
6         type tinyint not null,
7         length int not null,
8         tdefault int not null,
9         domain int not null,
10        name longsysname(255) not null,
11        printfmt varchar(255) null,
12        prec tinyint null,
13        scale tinyint null,
14        ident tinyint null,
15        hierarchy tinyint null,
16        xtypeid int null,
17        xdbid int null,
18        accessrule int null
19    )
20    
21    create unique clustered index csystypes on systypes(-- 6 KB refcount: 1
22        name
23    )
24    create unique index ncsystypes on systypes(-- 6 KB refcount: 0
25        usertype
26    )
27    
28    alter table systypes lock datarows
29    
30    Grant Select on systypes to public
31    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[type]sybsystemprocs..syscolumns[type]2 Simple Join

Estimated Index Usage
systypes.csystypes unique clustered(name)1
systypes.ncsystypes unique(usertype)0

ALIASES USED for master..systypes
tt1
11

SCHEMA

COLUMN USAGE
usertypesp_autoformat 
typesp_autoformat  sp_aux_encr_verify_downgrade 
namesp_autoformat  sp_aux_encr_verify_downgrade 

QUERIES
Joined With Links
sybsystemprocs..syscolumns sybsystemprocs..sysobjects sybsystemprocs..sp_aux_encr_verify_downgrade:415

DEPENDENCIES
READERS AND WRITERS
read by proc sybsystemprocs..sp_aux_encr_verify_downgrade  
read by proc sybsystemprocs..sp_autoformat  
   called by proc sybsystemprocs..sp_remoteoption  
   called by proc sybsystemprocs..sp_helpexternlogin  
   called by proc sybsystemprocs..sp_help_resource_limit  
   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_replication_path  
   called by proc sybsystemprocs..sp_ddlgen_database  
   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_helpapptrace  
   called by proc sybsystemprocs..sp_pkeys  
   called by proc sybsystemprocs..sp_addthreshold  
   called by proc sybsystemprocs..sp_securityprofile  
   called by proc sybsystemprocs..sp_setreptable  
   called by proc sybsystemprocs..sp_monitor_list  
   called by proc sybsystemprocs..sp_helpkey  
      called by proc sybsystemprocs..sp_help  
   called by proc sybsystemprocs..sp_cacheconfig  
      called by proc sybsystemprocs..sp_do_poolconfig  
         called by proc sybsystemprocs..sp_poolconfig  
   called by proc sybsystemprocs..sp_passwordpolicy  
      called by proc sybsystemprocs..sp_downgrade  
   called by proc sybsystemprocs..sp_helpcache  
   called by proc sybsystemprocs..sp_dbrecovery_order  
   called by proc sybsystemprocs..sp_setrepcol  
   called by proc sybsystemprocs..sp_help_qplan  
      called by proc sybsystemprocs..sp_cmp_all_qplans  
   called by proc sybsystemprocs..sp_helpserver  
   called by proc sybsystemprocs..sp_helpextendedproc  
   called by proc sybsystemprocs..sp_helprotect  
   called by proc sybsystemprocs..sp_helpjoins  
   called by proc sybsystemprocs..sp_version  
   called by proc sybsystemprocs..sp_help_rep_agent  
   called by proc sybsystemprocs..sp_options  
   called by proc sybsystemprocs..sp_monitor_procedure  
   called 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  
   called by proc sybsystemprocs..sp_aux_computeprivs  
      called by proc sybsystemprocs..sp_column_privileges  
      called by proc sybsystemprocs..sp_table_privileges  
   called by proc sybsystemprocs..sp_monitor_list_montypes  
      called by proc sybsystemprocs..sp_monitor_list  
   called by proc sybsystemprocs..sp_monitor_procstack  
   called by proc sybsystemprocs..sp_helpdevice  
   called by proc sybsystemprocs..sp_helpconfig  
   called by proc sybsystemprocs..sp_spaceused  
   called by proc sybsystemprocs..sp_monitor_statement  
   called by proc sybsystemprocs..sp_encryption  
      called by proc sybsystemprocs..sp_downgrade  
   called by proc sybsystemprocs..sp_setreplicate  
   called by proc sybsystemprocs..sp_helpjava  
   called by proc sybsystemprocs..sp_autoformat  
   called by proc sybsystemprocs..sp_column_privileges  
   called by proc sybsystemprocs..sp_config_rep_agent  
   called by proc sybsystemprocs..sp_droplogin  
   called by proc sybsystemprocs..sp_indsuspect  
   called 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  
   called by proc sybsystemprocs..sp_estspace  
   called by proc sybsystemprocs..sp_helpthread  
   called by proc sybsystemprocs..sp_helpconstraint  
   called by proc sybsystemprocs..sp_fkeys  
   called by proc sybsystemprocs..sp_helpgroup  
      called by proc sybsystemprocs..sp_helpuser  
   called by proc sybsystemprocs..sp_helpsegment  
   called by proc sybsystemprocs..sp_monitor_connection  
   called by proc sybsystemprocs..sp_dboption_flmode  
      called by proc sybsystemprocs..sp_dboption  
   called by proc sybsystemprocs..sp_who  
   called by proc sybsystemprocs..sp_displaylogin  
   called by proc sybsystemprocs..sp_helpindex  
   called by proc sybsystemprocs..sp_helpmaplogin  
   called by proc sybsystemprocs..sp_showcontrolinfo  
   called by proc sybsystemprocs..sp_helpdb  
   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_help  
   called by proc sybsystemprocs..sp_help_qpgroup  
   called by proc sybsystemprocs..sp_lookup  
   called by proc sybsystemprocs..sp_logintrigger  
      called by proc sybsystemprocs..sp_modifylogin  
   called by proc sybsystemprocs..sp_helpthreshold  
   called by proc sybsystemprocs..sp_helplanguage  
   called by proc sybsystemprocs..sp_multdb_show  
      called by proc sybsystemprocs..sp_tempdb  
   called by proc sybsystemprocs..sp_objectsegment  
   called by proc sybsystemprocs..sp_ijdbc_aux_computeprivs  
   called by proc sybsystemprocs..sp_helpobjectdef  
   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_helpuser  
   called by proc sybsystemprocs..sp_setrepproc  
   called by proc sybsystemprocs..sp_depends  
   called by proc sybsystemprocs..sp_helpremotelogin  
   called by proc sybsystemprocs..sp_helpartition  
      called by proc sybsystemprocs..sp_help  
   called by proc sybsystemprocs..sp_downgrade  
   called by proc sybsystemprocs..sp_monitor_event