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

1     create table sysalternates(-- 0 Rows, Data: 2 KB, Index: 4 KB
2         suid int not null,
3         altsuid int not null
4     )
5     
6     
7     create unique clustered index csysalternates on sysalternates(-- 2 KB refcount: 6
8         suid
9     )
10    
11    alter table sysalternates lock datarows
12    
13    Grant Select on sysalternates to public
14    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[altsuid]sybsystemprocs..sysusers[suid]1 Simple Join

Estimated Index Usage
sysalternates.csysalternates unique clustered(suid)6

ALIASES USED for sybsystemprocs..sysalternates
NO_ALIASasysalternates
914

SCHEMA

COLUMN USAGE
suidsp_addalias  sp_adduser  sp_changedbowner  sp_dropalias  sp_helpuser 
altsuidsp_addalias  sp_changedbowner  sp_dropuser  sp_helpuser 

QUERIES
Joined With Links

COLUMN WRITES detailed
ColumnWritten From
suid    syslogins.suid   sp_gen_login_id.@?  
altsuid    syslogins.suid   sysusers.suid   sp_gen_login_id.@?   sp_adduser.@?   sp_addgroup.@?  

DEPENDENCIES
READERS AND WRITERS
read by proc sybsystemprocs..sp_helpuser  
read_written by proc sybsystemprocs..sp_dropuser  
read by proc sybsystemprocs..sp_adduser  
read_written by proc sybsystemprocs..sp_changedbowner  
read_written by proc sybsystemprocs..sp_addalias  
written by proc sybsystemprocs..sp_dropalias