Database | Table | Application | Created | Links |
master | sysprocesses | 31 Aug 14 | Joins 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 | ||||||||||||
|
ALIASES USED for master..sysprocesses | |||
NO_ALIAS | mp | p | sysp |
22 | 6 | 1 | 6 |
SCHEMA |
COLUMN USAGE | |
spid | sp_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 |
status | sp_who |
suid | sp_clearpsexe sp_droplogin sp_helpapptrace sp_locklogin sp_monitor_connection sp_monitor_statement sp_multdb_show sp_setpsexe sp_showpsexe sp_who |
hostname | sp_client_addr sp_who |
program_name | sp_multdb_show sp_showpsexe |
cmd | sp_opt_querystats_main sp_showpsexe sp_who |
blocked | sp_monitor_procstack sp_who |
dbid | sp_dropuser sp_who |
uid | sp_dropuser |
fid | sp_familylock sp_who |
execlass | sp_showpsexe |
priority | sp_setpsexe sp_showpsexe |
affinity | sp_showpsexe sp_who |
stmtnum | sp_monitor_procstack |
linenum | sp_monitor_procstack |
origsuid | sp_who |
block_xloid | sp_who |
ipaddr | sp_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 |