DatabaseTableApplicationCreatedLinks
sybsystemprocssyspartitionkeys  31 Aug 14Joins Schema ColumnUsage Queries Dependencies

1     create table syspartitionkeys(-- 0 Rows, Data: 2 KB, Index: 4 KB
2         indid smallint not null,
3         id int not null,
4         colid smallint not null,
5         position smallint not null
6     )
7     
8     create unique clustered index csyspartitionkeys on syspartitionkeys(-- 2 KB refcount: 8
9         id, indid, colid
10    )
11    
12    alter table syspartitionkeys lock datarows
13    
14    Grant Select on syspartitionkeys to public
15    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[id, indid]sybsystemprocs..sysindexes[id, indid]4 FK
[id, colid]sybsystemprocs..syscolumns[id, colid]4 Simple Join
[colid, id]sybsystemprocs..syscolumns[id, colid]2 Simple Join
[indid]sybsystemprocs..sysindexes[indid]2 Simple Join

Estimated Index Usage
syspartitionkeys.csyspartitionkeys unique clustered(id, indid, colid)8

ALIASES USED for sybsystemprocs..syspartitionkeys
kp
22

SCHEMA

COLUMN USAGE
indidsp_helpartition  sp_post_xpload 
idsp_helpartition  sp_post_xpload 
colidsp_helpartition  sp_post_xpload 
positionsp_helpartition 

QUERIES
Joined With Links
sybsystemprocs..syscolumns sybsystemprocs..sp_helpartition:224
sybsystemprocs..syscolumns sybsystemprocs..sysindexes sybsystemprocs..sp_post_xpload:128
sybsystemprocs..sp_post_xpload:145
sybsystemprocs..sysindexes sybsystemprocs..sp_helpartition:320

DEPENDENCIES
READERS AND WRITERS
read by proc sybsystemprocs..sp_helpartition  
   called by proc sybsystemprocs..sp_help  
read by proc sybsystemprocs..sp_post_xpload