DatabaseTableApplicationCreatedLinks
mastersysloginroles  31 Aug 14Joins Schema ColumnUsage Queries Dependencies

1     create table sysloginroles(-- 0 Rows, Data: 2 KB, Index: 4 KB
2         suid int not null,
3         srid int not null,
4         status smallint not null
5     )
6     
7     create clustered index csysloginroles on sysloginroles(-- 2 KB refcount: 33
8         suid
9     )
10    
11    alter table sysloginroles lock datarows
12    
13    Grant Select on sysloginroles to sso_role
14    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[suid]master..syslogins[suid]22 FK
[srid]master..syssrvroles[srid]18 FK

Estimated Index Usage
sysloginroles.csysloginroles clustered(suid)33

ALIASES USED for master..sysloginroles
NO_ALIASlmsrrsrolesysloginroles
24810113

SCHEMA

COLUMN USAGE
suidsp_activeroles  sp_aux_encr_verify_downgrade  sp_aux_securityprofile_getattr  sp_changedbowner  sp_displaylogin  sp_displayroles  sp_droplogin  sp_helprotect  sp_is_valid_user  sp_locklogin  sp_modifylogin 
sridsp_activeroles  sp_aux_encr_verify_downgrade  sp_aux_securityprofile_getattr  sp_changedbowner  sp_displaylogin  sp_displayroles  sp_helprotect  sp_is_valid_user  sp_locklogin  sp_modifylogin 
statussp_aux_securityprofile_getattr  sp_displaylogin  sp_modifylogin 

QUERIES
Joined With Links
master..syslogins sybsystemprocs..sp_locklogin:559
sybsystemprocs..sp_locklogin:611
sybsystemprocs..sp_locklogin:641
master..syslogins sybsystemprocs..sp_locklogin:552
sybsystemprocs..sp_locklogin:618
sybsystemprocs..sp_locklogin:648
sybsystemprocs..sp_aux_encr_verify_downgrade:238
master..syssrvroles 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_aux_securityprofile_getattr  
   called by proc sybsystemprocs..sp_securityprofile  
read by proc sybsystemprocs..sp_displayroles  
written by proc sybsystemprocs..sp_droplogin  
read by proc sybsystemprocs..sp_activeroles  
read by proc sybsystemprocs..sp_is_valid_user  
   called by proc sybsystemprocs..sp_optimal_text_space  
      called by proc sybsystemprocs..sp_chgattribute  
   called by proc sybsystemprocs..sp_plan_dbccdb  
read by proc sybsystemprocs..sp_locklogin  
   called by proc sybsystemprocs..sp_droplogin  
   called by proc sybsystemprocs..sp_addlogin  
read by proc sybsystemprocs..sp_changedbowner  
read by proc sybsystemprocs..sp_helprotect  
read_written by proc sybsystemprocs..sp_modifylogin  
read by proc sybsystemprocs..sp_aux_encr_verify_downgrade  
read by proc sybsystemprocs..sp_displaylogin