Database | Table | Application | Created | Links |
sybsystemprocs | sysconstraints | 31 Aug 14 | Joins 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 | ||||||||||||||||||
|
Estimated Index Usage | |
sysconstraints.csysconstraints clustered(tableid, colid) | 12 |
sysconstraints.ncsysconstraints unique(constrid) | 10 |
ALIASES USED for sybsystemprocs..sysconstraints | |||
NO_ALIAS | c | con | sysconstraints |
9 | 6 | 1 | 2 |
SCHEMA |
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 |