DatabaseTableApplicationCreatedLinks
mastersysremotelogins  31 Aug 14Joins Schema ColumnUsage Queries Dependencies

1     create table sysremotelogins(-- 0 Rows, Data: 0 B, Index: 0 B
2         remoteserverid smallint not null,
3         remoteusername varchar(30) null,
4         suid int not null,
5         status smallint not null
6     )
7     
8     create unique clustered index csysremotelogins on sysremotelogins(-- 2 KB refcount: 30
9         remoteserverid, remoteusername
10    )
11    
12    alter table sysremotelogins lock datarows
13    
14    Grant Select on sysremotelogins to public
15    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[remoteserverid]master..sysservers[srvid]28 FK
[remoteusername]master..spt_values[name]4 Simple Join
[status]master..spt_values[number]4 Simple Join

Estimated Index Usage
sysremotelogins.csysremotelogins unique clustered(remoteserverid, remoteusername)30

ALIASES USED for master..sysremotelogins
NO_ALIASlrsysremotelogins
3575

SCHEMA

COLUMN USAGE
remoteserveridsp_addremotelogin  sp_checknames  sp_dropremotelogin  sp_dropserver  sp_helpremotelogin  sp_remoteoption 
remoteusernamesp_addremotelogin  sp_checknames  sp_checkreswords  sp_dropremotelogin  sp_helpremotelogin  sp_remoteoption 
suidsp_addremotelogin  sp_droplogin  sp_dropremotelogin  sp_helpremotelogin  sp_remoteoption 
statussp_addremotelogin  sp_helpremotelogin  sp_remoteoption 

QUERIES
Joined With Links
master..spt_values sybsystemprocs..sp_checkreswords:369
sybsystemprocs..sp_checkreswords:365
master..sysservers master..spt_values sybsystemprocs..sp_helpremotelogin:142
master..sysmessages master..sysservers master..spt_values sybsystemprocs..sp_helpremotelogin:161
master..sysservers sybsystemprocs..sp_addremotelogin:352
sybsystemprocs..sp_addremotelogin:210
sybsystemprocs..sp_addremotelogin:281
sybsystemprocs..sp_dropserver:255
sybsystemprocs..sp_remoteoption:175
sybsystemprocs..sp_remoteoption:360
sybsystemprocs..sp_addremotelogin:306
sybsystemprocs..sp_helpremotelogin:46
sybsystemprocs..sp_dropremotelogin:163
sybsystemprocs..sp_helpremotelogin:100
sybsystemprocs..sp_dropserver:294
sybsystemprocs..sp_remoteoption:335

DEPENDENCIES
READERS AND WRITERS
read by proc sybsystemprocs..sp_checkreswords  
read by proc sybsystemprocs..sp_checknames  
read by proc sybsystemprocs..sp_helpremotelogin  
read_written by proc sybsystemprocs..sp_remoteoption  
written by proc sybsystemprocs..sp_droplogin  
written by proc sybsystemprocs..sp_dropremotelogin  
read_written by proc sybsystemprocs..sp_addremotelogin  
read_written by proc sybsystemprocs..sp_dropserver