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

1     create table sysconstraints(-- 0 Rows, Data: 2 KB, Index: 2 KB
2         colid smallint not null,
3         constrid int not null,
4         tableid int not null,
5         error int not null,
6         status int not null,
7         spare2 int not null
8     )
9     
10    
11    create unique index ncsysconstraints on sysconstraints(-- 2 KB refcount: 11
12        constrid
13    )
14    create clustered index csysconstraints on sysconstraints(-- 2 KB refcount: 13
15        tableid, colid
16    )
17    
18    alter table sysconstraints lock datarows
19    
20    Grant Select on sysconstraints to public
21    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[constrid]sybsystemprocs..sysobjects[id]2 FK1-1
[tableid]sybsystemprocs..sysobjects[id]2 FK

Estimated Index Usage
sysconstraints.csysconstraints clustered(tableid, colid)13
sysconstraints.ncsysconstraints unique(constrid)11

ALIASES USED for sybsystemprocs..sysconstraints
NO_ALIAScconsysconstraintstrig
106121

SCHEMA

COLUMN USAGE
colidsp_bindrule  sp_depends  sp_depends_cols  sp_helptrigger  sp_unbindrule 
constridsp_bindmsg  sp_bindrule  sp_depends  sp_depends_cols  sp_help  sp_helpconstraint  sp_helptrigger  sp_unbindmsg  sp_unbindrule 
tableidsp_bindmsg  sp_bindrule  sp_depends  sp_depends_cols  sp_helpconstraint  sp_helptrigger  sp_unbindmsg  sp_unbindrule 
errorsp_bindmsg  sp_helpconstraint  sp_unbindmsg 
statussp_depends  sp_depends_cols  sp_help  sp_helptrigger 

QUERIES
Joined With Links
sybsystemprocs..sysobjects sybsystemprocs..sp_bindrule:312
sybsystemprocs..sp_unbindmsg:172
sybsystemprocs..sp_bindmsg:199
sybsystemprocs..syscomments sybsystemprocs..sysobjects sybsystemprocs..sp_helpconstraint:230

COLUMN WRITES detailed
ColumnWritten From
error  sp_bindmsg.@msgid   sp_unbindmsg.@?  

DATA PROPAGATION detailed
ColumnWritten To
constridsyscolumns.domain  

DEPENDENCIES
READERS AND WRITERS
read by proc sybsystemprocs..sp_helpconstraint  
read by proc sybsystemprocs..sp_depends_cols  
   called by proc sybsystemprocs..sp_depends  
read_written by proc sybsystemprocs..sp_unbindmsg  
read by proc sybsystemprocs..sp_bindrule  
read by proc sybsystemprocs..sp_helptrigger  
read by proc sybsystemprocs..sp_unbindrule  
read by proc sybsystemprocs..sp_depends  
read_written by proc sybsystemprocs..sp_bindmsg  
read by proc sybsystemprocs..sp_help