DatabaseTableApplicationCreatedLinks
sybsystemdbsyscoordinations  31 Aug 14Joins Schema ColumnUsage Queries Dependencies

1     create table syscoordinations(-- 0 Rows, Data: 2 KB, Index: 4 KB
2         participant smallint not null,
3         starttime datetime not null,
4         coordtype tinyint not null,
5         owner tinyint not null,
6         protocol smallint not null,
7         state int not null,
8         bootcount int not null,
9         dbid smallint not null,
10        logvers tinyint not null,
11        spare tinyint not null,
12        status int not null,
13        xactkey binary(14) not null,
14        gtrid varchar(255) null,
15        partdata varbinary(255) null,
16        srvname varchar(30) null,
17        nodeid tinyint null
18    )
19    
20    create unique clustered index csyscoordinations on syscoordinations(-- 2 KB refcount: 3
21        xactkey, participant, owner
22    )
23    
24    alter table syscoordinations lock datarows
25    
26    Grant Select on syscoordinations to public
27    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[participant]master..sysservers[srvid]2 FK

Estimated Index Usage
syscoordinations.csyscoordinations unique clustered(xactkey, participant, owner)3

ALIASES USED for sybsystemdb..syscoordinations
csyscoordinations
11

SCHEMA

COLUMN USAGE
participantsp_dropserver 
ownersp_dropserver  sp_dtx_purge_completedxacts 
statussp_dtx_purge_completedxacts 

QUERIES
Joined With Links
master..sysservers sybsystemprocs..sp_dropserver:238

DEPENDENCIES
READERS AND WRITERS
written by proc sybsystemprocs..sp_dtx_purge_completedxacts  
read_written by proc sybsystemprocs..sp_dropserver