DatabaseTableApplicationCreatedLinks
sybsystemprocssyspartitionkeys  14 déc. 14Joins Schema ColumnUsage Queries Writes Propagation Dependencies

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

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