Database | Table | Application | Created | Links |
master | sysmessages | 31 Aug 14 | Joins Schema ColumnUsage Queries Dependencies |
1 create table sysmessages(-- 9.6 KRows, Data: 1 MB, Index: 1.3 MB 2 error int not null, 3 severity smallint not null, 4 dlevel smallint not null, 5 description varchar(1024) not null, 6 langid smallint null, 7 sqlstate varchar(5) null 8 ) 9 10 create unique index ncsysmessages on sysmessages(-- 254 KB refcount: 157 11 error, dlevel, langid 12 ) 13 create clustered index sysmessages on sysmessages(-- 1 MB refcount: 0 14 error, dlevel 15 ) 16 17 Grant Select on sysmessages to public 18
JOINS | ||||||||||||
|
Estimated Index Usage | |
sysmessages.ncsysmessages unique(error, dlevel, langid) | 157 |
sysmessages.sysmessages clustered(error, dlevel) | 0 |
ALIASES USED for master..sysmessages | ||||||
NO_ALIAS | m | m0 | m1 | m2 | mi | sysmessages |
77 | 24 | 1 | 2 | 2 | 7 | 6 |
SCHEMA |