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
| Estimated Index Usage |
| syscoordinations.csyscoordinations unique clustered(xactkey, participant, owner) | 3 |
| ALIASES USED for sybsystemdb..syscoordinations |
| c | syscoordinations |
| 1 | 1 |
| SCHEMA |
 |