DatabaseTableApplicationCreatedLinks
sybsystemprocssysusers  31 Aug 14Joins Schema ColumnUsage Queries Dependencies

1     create table sysusers(-- 18 Rows, Data: 2 KB, Index: 8 KB
2         suid int not null,
3         uid int not null,
4         gid int not null,
5         name sysname not null,
6         environ varchar(255) null
7     )
8     
9     create unique index ncsysusers1 on sysusers(-- 2 KB refcount: 35
10        name
11    )
12    create unique index ncsysusers2 on sysusers(-- 2 KB refcount: 87
13        uid
14    )
15    create clustered index csysusers on sysusers(-- 2 KB refcount: 15
16        suid
17    )
18    
19    alter table sysusers lock datarows
20    
21    Grant Select on sysusers to public
22    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[gid]sybsystemprocs..sysprotects[uid]26 Simple Join
[uid]sybsystemprocs..sysobjects[uid]20 Rev FK
[suid]master..syslogins[suid]4 FK
[name]master..spt_values[name]4 Rev FK
[uid]sybsystemprocs..sysencryptkeys[uid]4 Rev FK
[uid]sybsystemprocs..systypes[uid]4 Rev FK
[uid]sybsystemprocs..sysroles[lrid]2 FK1-1
[gid]sybsystemprocs..sysusers[uid]2 FK
[suid]master..sysdatabases[suid]2 Simple Join
[suid]sybsystemprocs..sysalternates[altsuid]2 Simple Join
[uid]sybsystemprocs..sysprotects[grantor]2 Rev FK
[uid]sybsystemprocs..sysprotects[uid]2 Rev FK
[uid]sybsystemprocs..sysusers[gid]2 Rev FK

Estimated Index Usage
sysusers.ncsysusers2 unique(uid)87
sysusers.ncsysusers1 unique(name)35
sysusers.csysusers clustered(suid)15

ALIASES USED for sybsystemprocs..sysusers
GNO_ALIASbgssusysusersuu1u2
1681521444029

SCHEMA

COLUMN USAGE
suidsp_addalias  sp_addgroup  sp_addthreshold  sp_adduser  sp_aux_encr_verify_downgrade  sp_changedbowner  sp_checknames  sp_dropuser  sp_encryption  sp_helprotect  sp_helpuser  sp_ijdbc_getschemas  sp_is_dbo  sp_jdbc_getschemas  sp_jdbc_getschemas_cts  sp_jdbc_stored_procedures  sp_modifythreshold 
uidsp_addalias  sp_addgroup  sp_addthreshold  sp_adduser  sp_aux_computeprivs  sp_aux_encr_verify_downgrade  sp_bindexeclass  sp_changedbowner  sp_changegroup  sp_checknames  sp_column_privileges  sp_depends  sp_dropgroup  sp_droptype  sp_dropuser  sp_encryption  sp_helpgroup  sp_helprotect  sp_helpuser  sp_ijdbc_aux_computeprivs  sp_ijdbc_getcolumnprivileges  sp_ijdbc_getprocedurecolumns  sp_ijdbc_stored_procedures  sp_indsuspect  sp_is_dbo  sp_jdbc_computeprivs  sp_jdbc_getcolumnprivileges  sp_jdbc_getsupertypes  sp_jdbc_stored_procedures  sp_modifystats  sp_modifythreshold  sp_odbc_computeprivs  sp_odbc_getcolumnprivileges  sp_odbc_gettableprivileges  sp_odbc_stored_procedures  sp_odbc_tables  sp_oledb_computeprivs  sp_oledb_getcolumnprivileges  sp_oledb_gettableprivileges  sp_oledb_statistics  sp_oledb_stored_procedures  sp_oledb_tables  sp_oledb_views  sp_replication_path  sp_showcontrolinfo  sp_stored_procedures  sp_tables  sp_table_privileges  sp_tab_suspectptn  sp_unbindexeclass 
gidsp_addgroup  sp_adduser  sp_aux_computeprivs  sp_changegroup  sp_dropgroup  sp_helpgroup  sp_helprotect  sp_helpuser  sp_ijdbc_aux_computeprivs  sp_ijdbc_getcolumnprivileges  sp_ijdbc_stored_procedures  sp_jdbc_computeprivs  sp_jdbc_getcolumnprivileges  sp_jdbc_stored_procedures  sp_modifystats  sp_odbc_computeprivs  sp_odbc_stored_procedures  sp_odbc_tables  sp_oledb_computeprivs  sp_oledb_statistics  sp_oledb_stored_procedures  sp_oledb_tables  sp_oledb_views  sp_stored_procedures  sp_tables 
namesp_addalias  sp_addgroup  sp_adduser  sp_aux_computeprivs  sp_aux_encr_verify_downgrade  sp_bindexeclass  sp_changegroup  sp_checknames  sp_checkreswords  sp_column_privileges  sp_depends  sp_dropgroup  sp_droptype  sp_dropuser  sp_helpgroup  sp_helprotect  sp_helpuser  sp_ijdbc_aux_computeprivs  sp_ijdbc_getcolumnprivileges  sp_ijdbc_getschemas  sp_indsuspect  sp_jdbc_computeprivs  sp_jdbc_getcolumnprivileges  sp_jdbc_getschemas  sp_jdbc_getschemas_cts  sp_jdbc_getsupertypes  sp_odbc_computeprivs  sp_odbc_getcolumnprivileges  sp_odbc_gettableprivileges  sp_oledb_computeprivs  sp_oledb_getcolumnprivileges  sp_oledb_gettableprivileges  sp_replication_path  sp_showcontrolinfo  sp_table_privileges  sp_tab_suspectptn  sp_unbindexeclass 
environsp_addgroup 

QUERIES
Joined With Links
master..sysmessages sybsystemprocs..sysobjects master..spt_values master..spt_values sybsystemprocs..sp_helpuser:94
sybsystemprocs..syscolumns sybsystemprocs..sysobjects sybsystemprocs..sp_depends:263
sybsystemprocs..sp_droptype:131
sybsystemprocs..sysobjects sybsystemprocs..sp_checknames:319
sybsystemprocs..sysindexes sybsystemprocs..sysobjects master..spt_values sybsystemprocs..sp_tab_suspectptn:69
master..spt_values sybsystemprocs..sp_checkreswords:272
sybsystemprocs..sp_checkreswords:276
sybsystemprocs..sysdepends sybsystemprocs..sysobjects master..spt_values sybsystemprocs..sp_depends:213
sybsystemprocs..sysdepends master..sysmessages master..sysmessages master..sysmessages sybsystemprocs..sysobjects master..spt_values master..spt_values master..spt_values sybsystemprocs..sp_depends:171
sybsystemprocs..syscolumns master..sysdatabases sybsystemprocs..sysobjects sybsystemprocs..sp_aux_encr_verify_downgrade:294
sybsystemprocs..sysindexes sybsystemprocs..sysobjects sybsystemprocs..syspartitions master..spt_values sybsystemprocs..sp_tab_suspectptn:128
sybsystemprocs..sysobjects sybsystemprocs..sysprotects sybsystemprocs..sp_oledb_stored_procedures:189
sybsystemprocs..sp_oledb_tables:343
sybsystemprocs..sp_oledb_views:282
sybsystemprocs..sp_jdbc_stored_procedures:348
sybsystemprocs..sp_odbc_stored_procedures:184
sybsystemprocs..sp_stored_procedures:189
sybsystemprocs..sp_oledb_statistics:279
sybsystemprocs..sp_ijdbc_stored_procedures:179
sybsystemprocs..sp_jdbc_stored_procedures:198
sybsystemprocs..sp_tables:305
sybsystemprocs..sp_jdbc_stored_procedures:305
sybsystemprocs..sp_odbc_tables:302
sybsystemprocs..sysindexes sybsystemprocs..sysobjects sybsystemprocs..sp_indsuspect:56
sybsystemprocs..sp_indsuspect:115
sybsystemprocs..systypes sybsystemprocs..systypes sybsystemprocs..sp_helpuser:150
sybsystemprocs..sp_jdbc_getsupertypes:21
sybsystemprocs..sysprotects sybsystemprocs..sp_dropuser:345
sybsystemprocs..sp_modifystats:279
sybsystemprocs..sp_aux_encr_verify_downgrade:210
sybsystemprocs..sp_helpgroup:60
sybsystemprocs..sysroles sybsystemprocs..sp_helpgroup:33

DEPENDENCIES
READERS AND WRITERS
read by proc sybsystemprocs..sp_jdbc_getsupertypes  
read by proc sybsystemprocs..sp_odbc_computeprivs  
   called by proc sybsystemprocs..sp_odbc_gettableprivileges  
   called by proc sybsystemprocs..sp_odbc_getcolumnprivileges  
read by proc sybsystemprocs..sp_oledb_stored_procedures  
read by proc sybsystemprocs..sp_indsuspect  
read by proc sybsystemprocs..sp_droptype  
read by proc sybsystemprocs..sp_aux_computeprivs  
   called by proc sybsystemprocs..sp_table_privileges  
   called by proc sybsystemprocs..sp_column_privileges  
read by proc sybsystemprocs..sp_jdbc_getschemas_cts  
read by proc sybsystemprocs..sp_odbc_stored_procedures  
read by proc sybsystemprocs..sp_tables  
read by proc sybsystemprocs..sp_oledb_computeprivs  
   called by proc sybsystemprocs..sp_oledb_gettableprivileges  
   called by proc sybsystemprocs..sp_oledb_getcolumnprivileges  
read by proc sybsystemprocs..sp_ijdbc_getcolumnprivileges  
read by proc sybsystemprocs..sp_encryption  
   called by proc sybsystemprocs..sp_downgrade  
read_written by proc sybsystemprocs..sp_changegroup  
read by proc sybsystemprocs..sp_ijdbc_aux_computeprivs  
read by proc sybsystemprocs..sp_odbc_tables  
read by proc sybsystemprocs..sp_checknames  
read by proc sybsystemprocs..sp_addthreshold  
read by proc sybsystemprocs..sp_helpjava  
read_written by proc sybsystemprocs..sp_changedbowner  
read by proc sybsystemprocs..sp_oledb_views  
read by proc sybsystemprocs..sp_ijdbc_getprocedurecolumns  
read by proc sybsystemprocs..sp_ijdbc_stored_procedures  
read_written by proc sybsystemprocs..sp_dropuser  
read by proc sybsystemprocs..sp_helpgroup  
   called by proc sybsystemprocs..sp_helpuser  
read by proc sybsystemprocs..sp_helprotect  
read by proc sybsystemprocs..sp_modifystats  
read by proc sybsystemprocs..sp_oledb_getcolumnprivileges  
read_written by proc sybsystemprocs..sp_adduser  
read by proc sybsystemprocs..sp_ijdbc_getschemas  
read by proc sybsystemprocs..sp_replication_path  
read by proc sybsystemprocs..sp_table_privileges  
read by proc sybsystemprocs..sp_oledb_statistics  
read by proc sybsystemprocs..sp_helpuser  
read by proc sybsystemprocs..sp_jdbc_getcolumnprivileges  
read by proc sybsystemprocs..sp_depends  
read by proc sybsystemprocs..sp_tab_suspectptn  
read by proc sybsystemprocs..sp_addalias  
read by proc sybsystemprocs..sp_aux_encr_verify_downgrade  
read by proc sybsystemprocs..sp_stored_procedures  
read by proc sybsystemprocs..sp_is_dbo  
read by proc sybsystemprocs..sp_oledb_gettableprivileges  
read by proc sybsystemprocs..sp_column_privileges  
read by proc sybsystemprocs..sp_odbc_getcolumnprivileges  
read by proc sybsystemprocs..sp_jdbc_stored_procedures  
read by proc sybsystemprocs..sp_jdbc_getschemas  
read by proc sybsystemprocs..sp_odbc_gettableprivileges  
read by proc sybsystemprocs..sp_oledb_tables  
read by proc sybsystemprocs..sp_bindexeclass  
read by proc sybsystemprocs..sp_showcontrolinfo  
read by proc sybsystemprocs..sp_modifythreshold  
read_written by proc sybsystemprocs..sp_addgroup  
read by proc sybsystemprocs..sp_checkreswords  
read_written by proc sybsystemprocs..sp_dropgroup  
read by proc sybsystemprocs..sp_unbindexeclass  
read by proc sybsystemprocs..sp_jdbc_computeprivs  
   called by proc sybsystemprocs..sp_jdbc_gettableprivileges