DatabaseTableApplicationCreatedLinks
mastersystransactions  31 Aug 14Joins Schema ColumnUsage Queries Dependencies

1     create table systransactions(-- 0 Rows, Data: 2 KB, Index: 0 B
2         xactkey binary(14) not null,
3         starttime datetime not null,
4         failover int not null,
5         type int not null,
6         coordinator int not null,
7         state int not null,
8         connection int not null,
9         status int not null,
10        status2 int not null,
11        spid smallint not null,
12        masterdbid smallint not null,
13        loid int not null,
14        namelen smallint not null,
15        xactname varchar(255) null,
16        srvname varchar(30) null,
17        nodeid tinyint null
18    )
19    
20    alter table systransactions lock datarows
21    
22    Grant Select on systransactions to public
23    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[connection]master..spt_values[number]12 Simple Join
[coordinator]master..spt_values[number]12 Simple Join
[failover]master..spt_values[number]12 Simple Join
[state]master..spt_values[number]12 Simple Join
[type]master..spt_values[number]12 Simple Join

ALIASES USED for master..systransactions
NO_ALIASs
37

SCHEMA

COLUMN USAGE
xactkeysp_transactions 
starttimesp_transactions 
failoversp_transactions 
typesp_transactions 
coordinatorsp_transactions 
statesp_transactions 
connectionsp_transactions 
spidsp_transactions 
masterdbidsp_transactions 
loidsp_transactions 
namelensp_transactions 
xactnamesp_transactions 
srvnamesp_transactions 

QUERIES
Joined With Links
master..spt_values master..spt_values master..spt_values master..spt_values master..spt_values sybsystemprocs..sp_transactions:95
sybsystemprocs..sp_transactions:266
sybsystemprocs..sp_transactions:141
sybsystemprocs..sp_transactions:314
sybsystemprocs..sp_transactions:63
sybsystemprocs..sp_transactions:290

DEPENDENCIES
READERS AND WRITERS
read by proc sybsystemprocs..sp_transactions