DatabaseTableApplicationCreatedLinks
sybsystemprocssyscomments  31 Aug 14Joins Schema ColumnUsage Queries 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    create unique clustered index csyscomments on syscomments(-- 628 KB refcount: 36
16        id, number, colid2, colid, texttype
17    )
18    
19    alter table syscomments lock datarows
20    
21    Grant Select on syscomments to public
22    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[id]sybsystemprocs..sysobjects[id]14 FK
[id]sybsystemprocs..syscolumns[cdefault]2 Simple Join
[partitionid]sybsystemprocs..syspartitions[partitionid]2 Simple Join

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

ALIASES USED for sybsystemprocs..syscomments
DDDNO_ALIAScmsyscomments
2217452

SCHEMA

COLUMN USAGE
idsp_bindefault  sp_drv_bcpmetadata  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_bcpmetadata  sp_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:139
sybsystemprocs..sp_merge_dup_inline_default:449
sybsystemprocs..sp_encryption:1520
sybsystemprocs..sp_merge_dup_inline_default:139
sybsystemprocs..sysobjects sybsystemprocs..sysprocedures sybsystemprocs..sp_merge_dup_inline_default:120
sybsystemprocs..sp_merge_dup_inline_default:120
sybsystemprocs..sp_merge_dup_inline_default:432
sybsystemprocs..sysconstraints sybsystemprocs..sysobjects sybsystemprocs..sp_helpconstraint:230
sybsystemprocs..syscolumns sybsystemprocs..sp_drv_bcpmetadata:141
sybsystemprocs..syspartitions sybsystemprocs..sp_helpartition:605

DEPENDENCIES
READERS AND WRITERS
read by proc sybsystemprocs..sp_bindefault  
read by proc sybsystemprocs..sp_drv_column_default  
   called by proc sybsystemprocs..sp_jdbc_columns  
   called by proc sybsystemprocs..sp_odbc_columns  
read by proc sybsystemprocs..sp_encryption  
   called by proc sybsystemprocs..sp_downgrade  
read by proc sybsystemprocs..sp_unbindefault  
read by proc sybsystemprocs..sp_drv_bcpmetadata  
read by proc sybsystemprocs..sp_helpartition  
   called by proc sybsystemprocs..sp_help  
read_written by proc sybsystemprocs..sp_merge_dup_inline_default  
read by proc sybsystemprocs..sp_showtext  
   called by proc sybsystemprocs..sp_helptext  
   called by proc sybsystemprocs..sp_helptext_usage  
      called by proc sybsystemprocs..sp_helptext  
read by proc sybsystemprocs..sp_helpcomputedcolumn  
   called by proc sybsystemprocs..sp_helpindex  
      called by proc sybsystemprocs..sp_help  
   called by proc sybsystemprocs..sp_help  
read by proc sybsystemprocs..sp_help  
read by proc sybsystemprocs..sp_helpconstraint  
read by proc sybsystemprocs..sp_helptext  
read by proc sybsystemprocs..sp_showtext_output  
   called by proc sybsystemprocs..sp_showtext