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

1     create table sysroles(-- 0 Rows, Data: 2 KB, Index: 4 KB
2         id int not null,
3         lrid int not null,
4         type smallint not null,
5         status int not null
6     )
7     
8     
9     create unique clustered index csysroles on sysroles(-- 2 KB refcount: 10
10        lrid
11    )
12    
13    alter table sysroles lock datarows
14    
15    Grant Select on sysroles to public
16    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[id]master..syssrvroles[srid]9 FK
[lrid]sybsystemprocs..sysprotects[uid]9 Rev FK
[lrid]sybsystemprocs..sysusers[uid]1 FK1-1

Estimated Index Usage
sysroles.csysroles unique clustered(lrid)10

ALIASES USED for sybsystemprocs..sysroles
Rro
19

SCHEMA

COLUMN USAGE
idsp_ijdbc_stored_procedures  sp_modifystats  sp_odbc_stored_procedures  sp_odbc_tables  sp_oledb_stored_procedures  sp_oledb_tables  sp_oledb_views  sp_stored_procedures  sp_tables 
lridsp_helpgroup  sp_ijdbc_stored_procedures  sp_modifystats  sp_odbc_stored_procedures  sp_odbc_tables  sp_oledb_stored_procedures  sp_oledb_tables  sp_oledb_views  sp_stored_procedures  sp_tables 

QUERIES
Joined With Links
sybsystemprocs..sysobjects sybsystemprocs..sysprotects master..syssrvroles sybsystemprocs..sp_oledb_views:313
sybsystemprocs..sp_stored_procedures:228
sybsystemprocs..sp_odbc_stored_procedures:209
sybsystemprocs..sp_ijdbc_stored_procedures:204
sybsystemprocs..sp_oledb_tables:371
sybsystemprocs..sp_tables:353
sybsystemprocs..sp_oledb_stored_procedures:212
sybsystemprocs..sp_odbc_tables:332
sybsystemprocs..sysusers sybsystemprocs..sp_helpgroup:33
sybsystemprocs..sysprotects master..syssrvroles sybsystemprocs..sp_modifystats:274

DEPENDENCIES
READERS AND WRITERS
read by proc sybsystemprocs..sp_helpgroup  
   called by proc sybsystemprocs..sp_helpuser  
read by proc sybsystemprocs..sp_odbc_stored_procedures  
read by proc sybsystemprocs..sp_stored_procedures  
read by proc sybsystemprocs..sp_tables  
read by proc sybsystemprocs..sp_oledb_stored_procedures  
read by proc sybsystemprocs..sp_oledb_tables  
read by proc sybsystemprocs..sp_odbc_tables  
read by proc sybsystemprocs..sp_ijdbc_stored_procedures  
read by proc sybsystemprocs..sp_modifystats  
read by proc sybsystemprocs..sp_oledb_views