DatabaseTableApplicationCreatedLinks
mastersysprocesses  31 Aug 14Joins Schema ColumnUsage Queries Dependencies

1     create table sysprocesses(-- 0 Rows, Data: 0 B, Index: 0 B
2         spid smallint not null,
3         kpid int not null,
4         enginenum int not null,
5         status char(12) not null,
6         suid int not null,
7         hostname varchar(30) null,
8         program_name varchar(30) null,
9         hostprocess varchar(30) null,
10        cmd varchar(30) null,
11        cpu int not null,
12        physical_io int not null,
13        memusage int not null,
14        blocked smallint not null,
15        dbid smallint not null,
16        uid int not null,
17        gid int not null,
18        tran_name varchar(64) null,
19        time_blocked int null,
20        network_pktsz int null,
21        fid smallint null,
22        execlass varchar(30) null,
23        priority varchar(10) null,
24        affinity varchar(30) null,
25        id int null,
26        stmtnum int null,
27        linenum int null,
28        origsuid int null,
29        block_xloid int null,
30        clientname varchar(30) null,
31        clienthostname varchar(30) null,
32        clientapplname varchar(30) null,
33        sys_id smallint null,
34        ses_id int null,
35        loggedindatetime datetime null,
36        ipaddr varchar(64) null,
37        nodeid tinyint null
38    )
39    
40    Grant Select on sysprocesses to public
41    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[suid]master..syslogins[suid]12 FK

ALIASES USED for master..sysprocesses
NO_ALIASmppsysp
22616

SCHEMA

COLUMN USAGE
spidsp_clearpsexe  sp_client_addr  sp_dropengine  sp_helpapptrace  sp_monitor_connection  sp_monitor_procstack  sp_monitor_statement  sp_multdb_show  sp_setpsexe  sp_showpsexe  sp_who 
statussp_who 
suidsp_clearpsexe  sp_droplogin  sp_helpapptrace  sp_locklogin  sp_monitor_connection  sp_monitor_statement  sp_multdb_show  sp_setpsexe  sp_showpsexe  sp_who 
hostnamesp_client_addr  sp_who 
program_namesp_multdb_show  sp_showpsexe 
cmdsp_opt_querystats_main  sp_showpsexe  sp_who 
blockedsp_monitor_procstack  sp_who 
dbidsp_dropuser  sp_who 
uidsp_dropuser 
fidsp_familylock  sp_who 
execlasssp_showpsexe 
prioritysp_setpsexe  sp_showpsexe 
affinitysp_showpsexe  sp_who 
stmtnumsp_monitor_procstack 
linenumsp_monitor_procstack 
origsuidsp_who 
block_xloidsp_who 
ipaddrsp_client_addr 

QUERIES
Joined With Links
master..syslogins sybsystemprocs..sp_locklogin:753
sybsystemprocs..sp_locklogin:790
sybsystemprocs..sp_locklogin:809
sybsystemprocs..sp_locklogin:840

DEPENDENCIES
READERS AND WRITERS
read by proc sybsystemprocs..sp_droplogin  
read by proc sybsystemprocs..sp_monitor_connection  
read by proc sybsystemprocs..sp_locklogin  
   called by proc sybsystemprocs..sp_droplogin  
   called by proc sybsystemprocs..sp_addlogin  
read by proc sybsystemprocs..sp_dropuser  
read by proc sybsystemprocs..sp_dropengine  
read by proc sybsystemprocs..sp_multdb_show  
   called by proc sybsystemprocs..sp_tempdb  
read by proc sybsystemprocs..sp_familylock  
read by proc sybsystemprocs..sp_setpsexe  
read by proc sybsystemprocs..sp_monitor_statement  
read by proc sybsystemprocs..sp_opt_querystats_main  
   called by proc sybsystemprocs..sp_opt_querystats  
read by proc sybsystemprocs..sp_showpsexe  
read by proc sybsystemprocs..sp_client_addr  
read by proc sybsystemprocs..sp_clearpsexe  
read by proc sybsystemprocs..sp_monitor_procstack  
read by proc sybsystemprocs..sp_who  
read by proc sybsystemprocs..sp_helpapptrace