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

1     create table syscolumns(-- 1.7 KRows, Data: 178 KB, Index: 248 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    
35    create unique clustered index csyscolumns on syscolumns(-- 70 KB refcount: 20
36        id, number, colid
37    )
38    
39    alter table syscolumns lock datarows
40    
41    Grant Select on syscolumns to public
42    
Estimated Index Usage
syscolumns.csyscolumns unique clustered(id, number, colid)20

ALIASES USED for master..syscolumns
NO_ALIASc
184

SCHEMA

COLUMN USAGE
idsp_addexternlogin  sp_addlanguage  sp_addlogin  sp_addremotelogin  sp_addserver  sp_addumpdevice  sp_config_rep_agent  sp_hadr_admin  sp_mon_gen_columnlist  sp_renamedb  sp_replication_path  sp_spaceusage 
colidsp_autoformat  sp_autoformat  sp_mon_gen_columnlist 
lengthsp_autoformat  sp_addexternlogin  sp_addlanguage  sp_addlogin  sp_addremotelogin  sp_addserver  sp_addumpdevice  sp_autoformat  sp_config_rep_agent  sp_hadr_admin  sp_renamedb  sp_replication_path  sp_spaceusage 
namesp_autoformat  sp_addexternlogin  sp_addlanguage  sp_addlogin  sp_addremotelogin  sp_addserver  sp_addumpdevice  sp_autoformat  sp_config_rep_agent  sp_hadr_admin  sp_mon_gen_columnlist  sp_renamedb  sp_replication_path  sp_spaceusage 

QUERIES
Joined With Links

DATA PROPAGATION detailed
ColumnWritten To
colidsp_autoformat_rset_001._clid#af sp_autoformat_rset_003._clid#af sp_autoformat_rset_004.sqlbNoName1 sp_autoformat_rset_005._clid#af sp_autoformat_rset_001._clid#af sp_autoformat_rset_003._clid#af sp_autoformat_rset_004.sqlbNoName74 sp_autoformat_rset_005._clid#af
lengthsp_autoformat_rset_001._colen#af sp_autoformat_rset_003._colen#af sp_autoformat_rset_005._colen#af sp_autoformat_rset_001._colen#af sp_autoformat_rset_003._colen#af sp_autoformat_rset_005._colen#af
namesp_autoformat_rset_001._clname#af °._maxlen#af °._asname#af sp_autoformat_rset_003._clname#af °._asname#af sp_autoformat_rset_005._clname#af °._asname#af sp_autoformat_rset_001._clname#af °._maxlen#af °._asname#af
sp_autoformat_rset_003._clname#af °._asname#af sp_autoformat_rset_005._clname#af °._asname#af

DEPENDENCIES
READERS AND WRITERS
read by proc sybsystemprocs..sp_spaceusage  
read by proc master..sp_autoformat  
   called by proc master..sp_configure  
      called by proc master..sp_configure  
   called by proc master..sp_dboption_flmode  
      called by proc master..sp_dboption  
   called by proc master..sp_autoformat  
read by proc sybsystemprocs..sp_mon_gen_columnlist  
   called by proc sybsystemprocs..sp_mon_archive_genSQL  
      called by proc sybsystemprocs..sp_mon_archive_monTable  
         called by proc sybsystemprocs..sp_mon_archive_deadlock  
      called by proc sybsystemprocs..sp_monitor_deadlock  
         called by proc sybsystemprocs..sp_monitor  
read by proc sybsystemprocs..sp_addlanguage  
read by proc sybsystemprocs..sp_addumpdevice  
read by proc sybsystemprocs..sp_addexternlogin  
read by proc sybsystemprocs..sp_addlogin  
read by proc sybsystemprocs..sp_addremotelogin  
read by proc sybsystemprocs..sp_config_rep_agent  
read by proc sybsystemprocs..sp_autoformat  
   called by proc sybsystemprocs..sp_setreplicate  
   called by proc sybsystemprocs..sp_ijdbc_aux_computeprivs  
   called by proc sybsystemprocs..sp_fkeys  
   called by proc sybsystemprocs..sp_helpuser  
   called by proc sybsystemprocs..sp_dbrecovery_order  
   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_monitor_connection  
   called by proc sybsystemprocs..sp_options  
   called by proc sybsystemprocs..sp_helpthread  
   called by proc sybsystemprocs..sp_displaylogin  
   called by proc sybsystemprocs..sp_depends  
   called by proc sybsystemprocs..sp_helpconstraint  
   called by proc sybsystemprocs..sp_securityprofile  
   called by proc sybsystemprocs..sp_monitor_event  
   called by proc sybsystemprocs..sp_helplanguage  
   called by proc sybsystemprocs..sp_helprotect  
   called by proc sybsystemprocs..sp_column_privileges  
   called by proc sybsystemprocs..sp_helpextendedproc  
   called by proc sybsystemprocs..sp_setreptable  
   called by proc sybsystemprocs..sp_helpdb  
   called by proc sybsystemprocs..sp_helpjava  
   called by proc sybsystemprocs..sp_helpthreshold  
   called by proc sybsystemprocs..sp_helpsegment  
   called by proc sybsystemprocs..sp_replication_path  
   called by proc sybsystemprocs..sp_helptrigger  
   called by proc sybsystemprocs..sp_config_rep_agent  
   called by proc sybsystemprocs..sp_help  
   called by proc sybsystemprocs..sp_setrepproc  
   called by proc sybsystemprocs..sp_setrepcol  
   called by proc sybsystemprocs..sp_helpgroup  
      called by proc sybsystemprocs..sp_helpuser  
   called by proc sybsystemprocs..sp_help_qplan  
      called by proc sybsystemprocs..sp_cmp_all_qplans  
   called by proc sybsystemprocs..sp_encryption  
      called by proc sybsystemprocs..sp_downgrade  
   called by proc sybsystemprocs..sp_config_dump  
      called by proc sybsystemprocs..sp_downgrade_dump_config  
   called by proc sybsystemprocs..sp_helpkey  
      called by proc sybsystemprocs..sp_help  
   called by proc sybsystemprocs..sp_helpexternlogin  
   called by proc sybsystemprocs..sp_dropuser  
   called by proc sybsystemprocs..sp_helpindex  
      called by proc sybsystemprocs..sp_help  
   called by proc sybsystemprocs..sp_autoformat  
   called by proc sybsystemprocs..sp_help_qpgroup  
   called by proc sybsystemprocs..sp_version  
   called by proc sybsystemprocs..sp_helpjoins  
   called by proc sybsystemprocs..sp_helpcache  
   called by proc sybsystemprocs..sp_remoteoption  
   called by proc sybsystemprocs..sp_estspace  
   called by proc sybsystemprocs..sp_downgrade  
   called by proc sybsystemprocs..sp_spaceused  
   called by proc sybsystemprocs..sp_helpremotelogin  
   called by proc sybsystemprocs..sp_monitor_procstack  
   called by proc sybsystemprocs..sp_monitor_deadlock_count_by  
      called by proc sybsystemprocs..sp_monitor_deadlock  
   called by proc sybsystemprocs..sp_who  
   called by proc sybsystemprocs..sp_help_rep_agent  
   called by proc sybsystemprocs..sp_helpdefrag  
   called by proc sybsystemprocs..sp_helpartition  
      called by proc sybsystemprocs..sp_help  
   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_logintrigger  
      called by proc sybsystemprocs..sp_modifylogin  
   called by proc sybsystemprocs..sp_multdb_show  
      called by proc sybsystemprocs..sp_tempdb  
   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  
   called by proc sybsystemprocs..sp_lookup  
   called by proc sybsystemprocs..sp_showcontrolinfo  
   called by proc sybsystemprocs..sp_passwordpolicy  
      called by proc sybsystemprocs..sp_downgrade  
   called by proc sybsystemprocs..sp_help_resource_limit  
   called by proc sybsystemprocs..sp_dwngd_helpindex  
   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_dboption_flmode  
      called by proc sybsystemprocs..sp_dboption  
   called by proc sybsystemprocs..sp_monitor_statement  
   called by proc sybsystemprocs..sp_hadr_admin  
      called by proc sybsystemprocs..sp_hadr_update  
   called by proc sybsystemprocs..sp_monitor_procedure  
   called by proc sybsystemprocs..sp_monitor_list_montypes  
      called by proc sybsystemprocs..sp_monitor_list  
   called by proc sybsystemprocs..sp_pkeys  
   called by proc sybsystemprocs..sp_helpobjectdef  
   called by proc sybsystemprocs..sp_dump_history  
   called by proc sybsystemprocs..sp_helpmaplogin  
   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_objectsegment  
   called by proc sybsystemprocs..sp_indsuspect  
   called by proc sybsystemprocs..sp_helpcomputedcolumn  
      called by proc sybsystemprocs..sp_help  
      called by proc sybsystemprocs..sp_helpindex  
   called by proc sybsystemprocs..sp_helpdevice  
   called by proc sybsystemprocs..sp_ddlgen_database  
   called by proc sybsystemprocs..sp_cacheconfig  
      called by proc sybsystemprocs..sp_do_poolconfig  
         called by proc sybsystemprocs..sp_poolconfig  
   called by proc sybsystemprocs..sp_helpapptrace  
   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_configure  
      called by proc sybsystemprocs..sp_downgrade_esd  
   called by proc sybsystemprocs..sp_helpserver  
   called by proc sybsystemprocs..sp_downgrade_esd  
   called by proc sybsystemprocs..sp_addthreshold  
read by proc sybsystemprocs..sp_addserver  
read by proc sybsystemprocs..sp_hadr_admin  
read by proc sybsystemprocs..sp_renamedb  
read by proc sybsystemprocs..sp_replication_path