Database	Table	Application	Created	Links
sybsystemprocs	systabstats		31 Aug 14	Joins Schema ColumnUsage Queries Dependencies

1     create table systabstats(-- 6 Rows, Data: 14 KB, Index: 16 KB
2         indid smallint not null,
3         id int not null,
4         activestatid smallint not null,
5         indexheight smallint not null,
6         leafcnt int not null,
7         pagecnt int not null,
8         rowcnt float not null,
9         forwrowcnt float not null,
10        delrowcnt float not null,
11        dpagecrcnt float not null,
12        ipagecrcnt float not null,
13        drowcrcnt float not null,
14        oamapgcnt int not null,
15        extent0pgcnt int not null,
16        datarowsize float not null,
17        leafrowsize float not null,
18        status int not null,
19        plljoindegree int not null,
20        rslastoam int not null,
21        rslastpage int not null,
22        frlastoam int not null,
23        frlastpage int not null,
24        conopt_thld smallint not null,
25        plldegree smallint not null,
26        emptypgcnt int not null,
27        partitionid int not null,
28        warmcachepgcnt int not null,
29        statmoddate datetime not null,
30        unusedpgcnt int not null,
31        oampagecnt int not null,
32        pioclmdata real not null,
33        pioclmindex real not null,
34        piocsmdata real not null,
35        piocsmindex real not null
36    )
37    
38    
39    create unique clustered index csystabstats on systabstats(-- 2 KB refcount: 6
40        id, indid, partitionid
41    )
42    
43    alter table systabstats lock datarows
44    
45    Grant Select on systabstats to public
46    

SCHEMA

DEPENDENCIES

READERS AND WRITERS read_written by proc sybsystemprocs..sp_chgattribute   read by proc sybsystemprocs..sp_help   read by proc sybsystemprocs..sp_spaceusage_object_init      called by proc sybsystemprocs..sp_spaceusage_object         called by proc sybsystemprocs..sp_spaceusage   read by proc sybsystemprocs..sp_spaceused