Database | Table | Application | Created | Links |
master | sysattributes | 31 Aug 14 | Joins Schema ColumnUsage Queries Dependencies |
1 create table sysattributes(-- 712 Rows, Data: 46 KB, Index: 88 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(-- 22 KB refcount: 335 20 class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo 21 ) 22 create index ncsysattributes on sysattributes(-- 20 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
JOINS | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Estimated Index Usage | |
sysattributes.csysattributes unique clustered(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo) | 335 |
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 |
187 | 17 | 2 | 1 | 6 | 4 | 2 | 4 | 77 | 1 | 1 |
SCHEMA |