DatabaseTableApplicationCreatedLinks
mastersyscomments  31 Aug 14Joins Schema ColumnUsage Queries Dependencies

1     create table syscomments(-- 674 Rows, Data: 194 KB, Index: 214 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(-- 20 KB refcount: 0
17        id, number, colid2, colid, texttype
18    )
19    
20    alter table syscomments lock datarows
21    
22    Grant Select on syscomments to public
23    
Estimated Index Usage
syscomments.csyscomments unique clustered(id, number, colid2, colid, texttype)0

ALIASES USED for master..syscomments
NO_ALIAS
1

SCHEMA

COLUMN USAGE
numbersp_showtext 
colidsp_showtext 
colid2sp_showtext 

QUERIES
Joined With Links

DEPENDENCIES
READERS AND WRITERS
read by proc sybsystemprocs..sp_showtext  
   called by proc sybsystemprocs..sp_helptext_usage  
      called by proc sybsystemprocs..sp_helptext  
   called by proc sybsystemprocs..sp_helptext