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
Estimated Index Usage |
syscomments.csyscomments unique clustered(id, number, colid2, colid, texttype) | 36 |
ALIASES USED for sybsystemprocs..syscomments |
D | DD | NO_ALIAS | c | m | syscomments |
2 | 2 | 17 | 4 | 5 | 2 |
SCHEMA |
|