DatabaseTableApplicationCreatedLinks
tempdbsyscolumns  31 Aug 14Joins Schema ColumnUsage Queries Dependencies

1     create table syscolumns(-- 0 Rows, Data: 24 KB, Index: 42 KB
2         id int not null,
3         number smallint not null,
4         colid smallint not null,
5         status tinyint not null,
6         type tinyint not null,
7         length int not null,
8         offset smallint not null,
9         usertype smallint not null,
10        cdefault int not null,
11        domain int not null,
12        name longsysname(255) not null,
13        printfmt varchar(255) null,
14        prec tinyint null,
15        scale tinyint null,
16        remote_type int null,
17        remote_name varchar(255) null,
18        xstatus int null,
19        xtype int null,
20        xdbid int null,
21        accessrule int null,
22        status2 int null,
23        status3 smallint not null,
24        computedcol int null,
25        encrtype int null,
26        encrlen int null,
27        encrkeyid int null,
28        encrkeydb sysname null,
29        encrdate datetime null,
30        lobcomp_lvl tinyint null,
31        inrowlen smallint null
32    )
33    
34    create unique clustered index csyscolumns on syscolumns(-- 18 KB refcount: 1
35        id, number, colid
36    )
37    
38    alter table syscolumns lock datarows
39    
40    Grant Select on syscolumns to public
41    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[usertype]tempdb..systypes[usertype]2 FK

Estimated Index Usage
syscolumns.csyscolumns unique clustered(id, number, colid)1

ALIASES USED for tempdb..syscolumns
c
1

SCHEMA

COLUMN USAGE
idsp_autoformat 
colidsp_autoformat 
lengthsp_autoformat 
usertypesp_autoformat 
namesp_autoformat 

QUERIES
Joined With Links
tempdb..systypes sybsystemprocs..sp_autoformat:354

DEPENDENCIES
READERS AND WRITERS
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