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

1     create table syspartitions(-- 75 Rows, Data: 8 KB, Index: 28 KB
2         name varchar(255) not null,
3         indid smallint not null,
4         id int not null,
5         partitionid int not null,
6         segment smallint not null,
7         status int not null,
8         datoampage int not null,
9         indoampage int not null,
10        firstpage int not null,
11        rootpage int not null,
12        data_partitionid int not null,
13        crdate datetime not null,
14        cdataptnname varchar(255) null,
15        lobcomp_lvl tinyint null,
16        ptndcompver tinyint null
17    )
18    
19    create unique clustered index csyspartitions on syspartitions(-- 6 KB refcount: 22
20        id, indid, partitionid
21    )
22    create unique index nc2syspartitions on syspartitions(-- 8 KB refcount: 2
23        id, indid, name
24    )
25    create unique index ncsyspartitions on syspartitions(-- 6 KB refcount: 0
26        partitionid, indid
27    )
28    
29    alter table syspartitions lock datarows
30    
31    Grant Select on syspartitions to public
32    

SCHEMA

DEPENDENCIES

READERS AND WRITERS read by proc sybsystemprocs..sp_helpindex      called by proc sybsystemprocs..sp_help   read by proc sybsystemprocs..sp_helplog   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_tab_suspectptn   read by proc sybsystemprocs..sp_helpsegment   read by proc sybsystemprocs..sp_helpartition      called by proc sybsystemprocs..sp_help   read by proc sybsystemprocs..sp_dropsegment   read_written by proc sybsystemprocs..sp_placeobject   read by proc sybsystemprocs..sp_objectsegment