DatabaseTableApplicationCreatedLinks
sybsystemprocssyspartitions  31 Aug 14Joins 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    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[segment]sybsystemprocs..syssegments[segment]16 Simple Join
[id, indid]sybsystemprocs..sysindexes[id, indid]6 FK
[id]sybsystemprocs..sysobjects[id]2 FK
[partitionid]sybsystemprocs..syscomments[partitionid]2 Simple Join
[indid]sybsystemprocs..sysindexes[indid]2 Simple Join

Estimated Index Usage
syspartitions.csyspartitions unique clustered(id, indid, partitionid)22
syspartitions.nc2syspartitions unique(id, indid, name)2
syspartitions.ncsyspartitions unique(partitionid, indid)0

ALIASES USED for sybsystemprocs..syspartitions
NO_ALIASpssyspartitions
71312

SCHEMA

COLUMN USAGE
namesp_helpartition  sp_helpindex  sp_helpsegment  sp_objectsegment  sp_spaceusage_object_init  sp_tab_suspectptn 
indidsp_helpartition  sp_helpindex  sp_helplog  sp_helpsegment  sp_objectsegment  sp_placeobject  sp_spaceusage_object_init  sp_tab_suspectptn 
idsp_helpartition  sp_helpindex  sp_helplog  sp_helpsegment  sp_objectsegment  sp_placeobject  sp_spaceusage_object_init  sp_tab_suspectptn 
partitionidsp_helpartition  sp_helplog  sp_placeobject  sp_spaceusage_object_init  sp_tab_suspectptn 
segmentsp_dropsegment  sp_helpartition  sp_helpindex  sp_helpsegment  sp_objectsegment  sp_placeobject 
statussp_helpartition 
datoampagesp_spaceusage_object_init 
indoampagesp_spaceusage_object_init 
firstpagesp_helplog 
data_partitionidsp_helpartition  sp_spaceusage_object_init 
crdatesp_helpartition  sp_objectsegment 
cdataptnnamesp_helpartition 

QUERIES
Joined With Links
sybsystemprocs..sysobjects sybsystemprocs..sp_helpartition:105
sybsystemprocs..sysindexes sybsystemprocs..sysobjects master..spt_values sybsystemprocs..sysusers sybsystemprocs..sp_tab_suspectptn:128
sybsystemprocs..sysindexes sybsystemprocs..sp_helpartition:339
sybsystemprocs..sysindexes sybsystemprocs..syssegments sybsystemprocs..sp_dropsegment:259
sybsystemprocs..sp_helpsegment:193
sybsystemprocs..syssegments sybsystemprocs..sp_helpindex:329
sybsystemprocs..sp_objectsegment:70
sybsystemprocs..sp_helpartition:566
sybsystemprocs..sp_helpartition:579
sybsystemprocs..sp_helpartition:490
sybsystemprocs..sp_helpsegment:183
sybsystemprocs..syscomments sybsystemprocs..sp_helpartition:605

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