DatabaseTableApplicationCreatedLinks
sybsystemprocssysconstraints  31 Aug 14Joins Schema ColumnUsage Queries 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    create unique index ncsysconstraints on sysconstraints(-- 2 KB refcount: 10
11        constrid
12    )
13    create clustered index csysconstraints on sysconstraints(-- 2 KB refcount: 12
14        tableid, colid
15    )
16    
17    alter table sysconstraints lock datarows
18    
19    Grant Select on sysconstraints to public
20    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[constrid]sybsystemprocs..sysobjects[id]4 FK1-1
[tableid]sybsystemprocs..sysobjects[id]4 FK

Estimated Index Usage
sysconstraints.csysconstraints clustered(tableid, colid)12
sysconstraints.ncsysconstraints unique(constrid)10

ALIASES USED for sybsystemprocs..sysconstraints
NO_ALIAScconsysconstraints
9612

SCHEMA

COLUMN USAGE
colidsp_bindrule  sp_depends  sp_depends_cols  sp_unbindrule 
constridsp_bindmsg  sp_bindrule  sp_depends  sp_depends_cols  sp_helpconstraint  sp_unbindmsg  sp_unbindrule 
tableidsp_bindmsg  sp_bindrule  sp_depends  sp_depends_cols  sp_helpconstraint  sp_unbindmsg  sp_unbindrule 
errorsp_bindmsg  sp_helpconstraint  sp_unbindmsg 
statussp_depends_cols 

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

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