1 create table sysattributes(-- 103 Rows, Data: 50 KB, Index: 68 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
20 create unique clustered index csysattributes on sysattributes(-- 10 KB refcount: 384
21 class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo
22 )
23 create index ncsysattributes on sysattributes(-- 8 KB refcount: 0
24 object_type, object, object_info1, object_info2, object_info3, object_cinfo, object_cinfo2, object_datetime
25 )
26
27 alter table sysattributes lock datarows
28
29 Grant Select on sysattributes to public
30
Estimated Index Usage |
sysattributes.csysattributes unique clustered(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo) | 384 |
sysattributes.ncsysattributes(object_type, object, object_info1, object_info2, object_info3, object_cinfo, object_cinfo2, object_datetime) | 0 |
ALIASES USED for master..sysattributes |
NO_ALIAS | a | an | att | b | c | cn | sa | sysattributes | t1 | t2 |
210 | 18 | 2 | 2 | 7 | 4 | 2 | 4 | 86 | 2 | 2 |
SCHEMA |
 |