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

1     create table syscomments(-- 64 Rows, Data: 16 KB, Index: 16 KB
2         id int not null,
3         number smallint not null,
4         colid smallint not null,
5         texttype smallint not null,
6         language smallint not null,
7         text varchar(255) null,
8         colid2 smallint not null,
9         status smallint null,
10        version smallint null,
11        partitionid int null,
12        encrkeyid int null
13    )
14    
15    
16    create unique clustered index csyscomments on syscomments(-- 708 KB refcount: 39
17        id, number, colid2, colid, texttype
18    )
19    
20    alter table syscomments lock datarows
21    
22    Grant Select on syscomments to public
23    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[id]sybsystemprocs..sysobjects[id]7 FK
[partitionid]sybsystemprocs..syspartitions[partitionid]1 Simple Join

Estimated Index Usage
syscomments.csyscomments unique clustered(id, number, colid2, colid, texttype)39

ALIASES USED for sybsystemprocs..syscomments
DDDNO_ALIAScmsyscomments
2216452

SCHEMA

COLUMN USAGE
idsp_bindefault  sp_drv_column_default  sp_encryption  sp_help  sp_helpartition  sp_helpcomputedcolumn  sp_helpconstraint  sp_helptext  sp_merge_dup_inline_default  sp_showtext  sp_showtext_output  sp_unbindefault 
numbersp_drv_column_default  sp_helpartition  sp_helptext  sp_merge_dup_inline_default  sp_showtext 
colidsp_drv_column_default  sp_encryption  sp_help  sp_helpartition  sp_helpcomputedcolumn  sp_helptext  sp_merge_dup_inline_default 
texttypesp_helptext  sp_merge_dup_inline_default 
textsp_drv_column_default  sp_help  sp_helpartition  sp_helpcomputedcolumn  sp_helpconstraint  sp_helptext  sp_merge_dup_inline_default 
colid2sp_drv_column_default  sp_help  sp_helpartition  sp_helpcomputedcolumn  sp_helptext  sp_merge_dup_inline_default 
statussp_bindefault  sp_drv_column_default  sp_help  sp_helpartition  sp_helpcomputedcolumn  sp_helpconstraint  sp_helptext  sp_merge_dup_inline_default  sp_showtext_output  sp_unbindefault 
partitionidsp_helpartition 
encrkeyidsp_encryption 

QUERIES
Joined With Links
sybsystemprocs..syscolumns sybsystemprocs..sysobjects sybsystemprocs..sp_helpconstraint:208
sybsystemprocs..sysobjects sybsystemprocs..sp_merge_dup_inline_default:161
sybsystemprocs..sp_merge_dup_inline_default:161
sybsystemprocs..sp_encryption:1609
sybsystemprocs..sp_merge_dup_inline_default:471
sybsystemprocs..sysobjects sybsystemprocs..sysprocedures sybsystemprocs..sp_merge_dup_inline_default:454
sybsystemprocs..sp_merge_dup_inline_default:142
sybsystemprocs..sp_merge_dup_inline_default:142
sybsystemprocs..sysconstraints sybsystemprocs..sysobjects sybsystemprocs..sp_helpconstraint:230
sybsystemprocs..syspartitions sybsystemprocs..sp_helpartition:617

COLUMN WRITES detailed
ColumnWritten From
text  sysobjects.name   sp_rename.@newname   sp_merge_dup_inline_default.@?  
status  syscomments.status   sp_merge_dup_inline_default.@?  

DATA PROPAGATION detailed
ColumnWritten To
idsyscolumns.cdefault   sp_oledb_columns_rset_001.COLUMN_HASDEFAULT sp_oledb_columns_rset_002.COLUMN_HASDEFAULT
numbersp_helptext_rset_003.text
statussyscomments.status  
textsp_helpconstraint_rset_002.definition sp_helpconstraint_rset_003.definition sp_helpconstraint_rset_004.definition sp_helptext_rset_001.# Lines of Text sp_helptext_rset_002.number

DEPENDENCIES
READERS AND WRITERS
read by proc sybsystemprocs..sp_helpconstraint  
read by proc sybsystemprocs..sp_bindefault  
read_written by proc sybsystemprocs..sp_merge_dup_inline_default  
read by proc sybsystemprocs..sp_help  
read by proc sybsystemprocs..sp_helpartition  
   called by proc sybsystemprocs..sp_help  
read by proc sybsystemprocs..sp_drv_column_default  
   called by proc sybsystemprocs..sp_odbc_columns  
   called by proc sybsystemprocs..sp_jdbc_columns  
read by proc sybsystemprocs..sp_encryption  
   called by proc sybsystemprocs..sp_downgrade  
read 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  
read by proc sybsystemprocs..sp_helptext  
read by proc sybsystemprocs..sp_showtext  
read by proc sybsystemprocs..sp_helpcomputedcolumn  
   called by proc sybsystemprocs..sp_help  
   called by proc sybsystemprocs..sp_helpindex  
      called by proc sybsystemprocs..sp_help  
read by proc sybsystemprocs..sp_unbindefault