DatabaseTableApplicationCreatedLinks
mastersyssrvroles  31 Aug 14Joins Schema ColumnUsage Queries Dependencies

1     create table syssrvroles(-- 0 Rows, Data: 2 KB, Index: 4 KB
2         srid int not null,
3         name varchar(30) not null,
4         password varbinary(128) null,
5         pwdate datetime null,
6         status smallint null,
7         logincount smallint null,
8         locksuid int null,
9         lockreason int null,
10        lockdate datetimn null
11    )
12    
13    create unique clustered index csyssrvroles on syssrvroles(-- 2 KB refcount: 27
14        srid
15    )
16    
17    alter table syssrvroles lock datarows
18    
19    Grant Select on syssrvroles to public
20    Grant Select on syssrvroles to sso_role
21    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[srid]master..sysloginroles[srid]18 Rev FK
[srid]sybsystemprocs..sysroles[id]18 Rev FK
[srid]master..spt_values[number]2 Rev FK
[srid]master..sysattributes[object_info2]2 Rev FK

Estimated Index Usage
syssrvroles.csyssrvroles unique clustered(srid)27

ALIASES USED for master..syssrvroles
NO_ALIASarrolenamesrvro
231919

SCHEMA

COLUMN USAGE
sridsp_activeroles  sp_addexternlogin  sp_addgroup  sp_changedbowner  sp_displaylogin  sp_displayroles  sp_dropexternlogin  sp_fix_dtm_ha_roles  sp_helpexternlogin  sp_helprotect  sp_ijdbc_stored_procedures  sp_locklogin  sp_modifystats  sp_odbc_stored_procedures  sp_odbc_tables  sp_oledb_stored_procedures  sp_oledb_tables  sp_oledb_views  sp_stored_procedures  sp_tables 
namesp_activeroles  sp_addexternlogin  sp_addgroup  sp_addlogin  sp_adduser  sp_changegroup  sp_displaylogin  sp_displayroles  sp_dropexternlogin  sp_dropgroup  sp_fix_dtm_ha_roles  sp_helpexternlogin  sp_helpgroup  sp_helprotect  sp_helpuser  sp_ijdbc_stored_procedures  sp_locklogin  sp_modifystats  sp_odbc_stored_procedures  sp_odbc_tables  sp_oledb_stored_procedures  sp_oledb_tables  sp_oledb_views  sp_passwordpolicy  sp_stored_procedures  sp_tables 
passwordsp_displayroles  sp_fix_dtm_ha_roles  sp_passwordpolicy 
pwdatesp_displayroles 
statussp_displayroles 
logincountsp_displayroles 
locksuidsp_displayroles 
lockreasonsp_displayroles 
lockdatesp_displayroles 

QUERIES
Joined With Links
sybsystemprocs..sysobjects sybsystemprocs..sysprotects sybsystemprocs..sysroles sybsystemprocs..sp_odbc_stored_procedures:207
sybsystemprocs..sp_oledb_views:310
sybsystemprocs..sp_odbc_tables:330
sybsystemprocs..sp_oledb_stored_procedures:212
sybsystemprocs..sp_stored_procedures:212
sybsystemprocs..sp_tables:333
sybsystemprocs..sp_oledb_tables:371
sybsystemprocs..sp_ijdbc_stored_procedures:204
master..sysattributes master..sysservers sybsystemprocs..sp_helpexternlogin:160
sybsystemprocs..sysprotects sybsystemprocs..sysroles sybsystemprocs..sp_modifystats:235
master..sysloginroles sybsystemprocs..sp_helprotect:468
sybsystemprocs..sp_locklogin:282
sybsystemprocs..sp_activeroles:105
sybsystemprocs..sp_activeroles:118
sybsystemprocs..sp_displayroles:520
sybsystemprocs..sp_helprotect:487
sybsystemprocs..sp_displayroles:536
sybsystemprocs..sp_helprotect:457
sybsystemprocs..sp_displayroles:493

DEPENDENCIES
READERS AND WRITERS
read by proc sybsystemprocs..sp_activeroles  
read by proc sybsystemprocs..sp_stored_procedures  
read by proc sybsystemprocs..sp_addlogin  
read by proc sybsystemprocs..sp_addgroup  
read by proc sybsystemprocs..sp_oledb_tables  
read by proc sybsystemprocs..sp_odbc_stored_procedures  
read by proc sybsystemprocs..sp_helprotect  
read by proc sybsystemprocs..sp_changedbowner  
read by proc sybsystemprocs..sp_helpgroup  
   called by proc sybsystemprocs..sp_helpuser  
read by proc sybsystemprocs..sp_dropgroup  
read by proc sybsystemprocs..sp_passwordpolicy  
   called by proc sybsystemprocs..sp_downgrade  
read by proc sybsystemprocs..sp_oledb_views  
read by proc sybsystemprocs..sp_changegroup  
read by proc sybsystemprocs..sp_ijdbc_stored_procedures  
read by proc sybsystemprocs..sp_displayroles  
read by proc sybsystemprocs..sp_odbc_tables  
read_written by proc sybsystemprocs..sp_fix_dtm_ha_roles  
read by proc sybsystemprocs..sp_addexternlogin  
read by proc sybsystemprocs..sp_helpexternlogin  
read by proc sybsystemprocs..sp_helpuser  
read by proc sybsystemprocs..sp_displaylogin  
read by proc sybsystemprocs..sp_tables  
read by proc sybsystemprocs..sp_oledb_stored_procedures  
read by proc sybsystemprocs..sp_modifystats  
read by proc sybsystemprocs..sp_locklogin  
   called by proc sybsystemprocs..sp_droplogin  
   called by proc sybsystemprocs..sp_addlogin  
read by proc sybsystemprocs..sp_dropexternlogin  
read by proc sybsystemprocs..sp_adduser