1 create table sysattributes(-- 31 Rows, Data: 2 KB, Index: 6 KB
2 class smallint not null,
3 attribute smallint not null,
4 object_type char(2) not null,
5 object_cinfo varchar(255) null,
6 object int null,
7 object_info1 int null,
8 object_info2 int null,
9 object_info3 int null,
10 int_value int null,
11 char_value varchar(768) null,
12 text_value text null,
13 image_value image null,
14 comments varchar(255) null,
15 object_cinfo2 varchar(255) null,
16 object_datetime datetimn null
17 )
18
19 create unique clustered index csysattributes on sysattributes(-- 2 KB refcount: 119
20 class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo
21 )
22 create index ncsysattributes on sysattributes(-- 2 KB refcount: 0
23 object_type, object, object_info1, object_info2, object_info3, object_cinfo, object_cinfo2, object_datetime
24 )
25
26 alter table sysattributes lock datarows
27
28 Grant Select on sysattributes to public
29
Estimated Index Usage |
sysattributes.csysattributes unique clustered(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo) | 119 |
sysattributes.ncsysattributes(object_type, object, object_info1, object_info2, object_info3, object_cinfo, object_cinfo2, object_datetime) | 0 |
ALIASES USED for sybsystemprocs..sysattributes |
NO_ALIAS | a | a1 | att1 | att2 | att3 | sysattributes | t |
66 | 5 | 2 | 2 | 2 | 2 | 17 | 4 |
SCHEMA |
|