DatabaseTableApplicationCreatedLinks
tempdb#spaceusageinfo_crby_sybsystemprocs__sp_spaceusage_object  01 Jan 70Joins Schema ColumnUsage Queries Dependencies

1     create table #spaceusageinfo(-- 0 Rows, Data: 0 B, Index: 0 B
2         VersionNum int not null,
3         ESDNum int not null,
4         EBFNum int not null,
5         ArchiveDateTime datetime not null,
6         ServerName varchar(255) null,
7         MaxPageSize int not null,
8         DBName varchar(30) not null,
9         OwnerName varchar(30) not null,
10        TableName varchar(255) not null,
11        Id int not null,
12        IndId smallint not null,
13        IndexName varchar(255) null,
14        PtnId int not null,
15        PtnName varchar(255) not null,
16        DataPtnId int not null,
17        RowSize float null,
18        NumRows float null,
19        RowCount_ts float null,
20        NumFwdRows float null,
21        NumDelRows float null,
22        EmptyPageCount int null,
23        DataPageCount int null,
24        UsedPageCount int null,
25        RsvdPageCount int null,
26        SpUtil decimal(9, 2) null,
27        DPCR decimal(5, 4) null,
28        DRCR decimal(5, 4) null,
29        IPCR decimal(5, 4) null,
30        LGIO decimal(5, 4) null,
31        FF smallint null,
32        MRPP smallint null,
33        ERS smallint null,
34        RPG smallint null,
35        LeafPageCount int null,
36        IndexHeight smallint null,
37        OAMAPageCount int null,
38        Extent0PageCount int null,
39        Status int null,
40        Sysstat smallint not null,
41        Sysstat2 int not null,
42        NonLeafRowSize decimal(10, 4) null,
43        ExpIndexHeight smallint null,
44        ExpDataPageCount int null,
45        ExpUsedPageCount int null,
46        ExpRsvdPageCount int null,
47        ExpLeafPageCount int null,
48        PctBloatUsedPages decimal(7, 2) null,
49        PctBloatRsvdPages decimal(7, 2) null,
50        PctBloatLeafPages decimal(7, 2) null,
51        ExtentUtil decimal(5, 2) null,
52        PctEmptyPages decimal(5, 2) null,
53        PctFwdRows decimal(5, 2) null,
54        LockScheme tinyint not null,
55        NumVarCols smallint not null,
56        HasAPLCI bit not null,
57        StatModDate date null,
58        SpacePerPage float null,
59        CalcRowsPerPage float null,
60        EmptyPages float null,
61        DataPages float null,
62        UsedPages float null,
63        RsvdPages float null,
64        LeafPages float null,
65        ExpDataPages float null,
66        ExpUsedPages float null,
67        ExpRsvdPages float null,
68        ExpLeafPages float null
69    )
70    
QUERIES
Joined With Links

DEPENDENCIES
READERS AND WRITERS
written by proc sybsystemprocs..sp_spaceusage_object  
   called by proc sybsystemprocs..sp_spaceusage