| Database | Table | Application | Created | Links |
| sybsystemdb | spt_committab | ![]() | 31 Aug 14 | Joins Schema ColumnUsage Queries Dependencies |
1 create table spt_committab(-- 0 Rows, Data: 2 KB, Index: 0 B 2 commid int not null, 3 suid int not null, 4 start datetime not null, 5 lastchange datetime not null, 6 totnum smallint not null, 7 outnum smallint not null, 8 heur char(1) not null, 9 status char(1) not null, 10 xid binary(140) not null, 11 applname varchar(30) not null, 12 xactname varchar(30) not null, 13 password varchar(30) null 14 ) 15 16 17 create unique clustered index commitclust on spt_committab(-- 2 KB refcount: 11 18 commid 19 ) with ignore_dup_key 20
| Estimated Index Usage | |
| spt_committab.commitclust unique clustered(commid) | 11 |
| ALIASES USED for sybsystemdb..spt_committab | |
| NO_ALIAS | spt_committab |
| 8 | 4 |
| SCHEMA |
![]() |
| COLUMN USAGE | |
| commid | sp_abort_xact sp_commit_xact sp_remove_xact sp_scan_xact sp_start_xact sp_stat_xact |
| suid | sp_start_xact |
| start | sp_scan_xact sp_start_xact |
| lastchange | sp_abort_xact sp_commit_xact sp_remove_xact sp_scan_xact sp_start_xact |
| totnum | sp_scan_xact sp_start_xact |
| outnum | sp_remove_xact sp_scan_xact sp_start_xact |
| heur | sp_start_xact |
| status | sp_abort_xact sp_commit_xact sp_scan_xact sp_start_xact sp_stat_xact |
| xid | sp_start_xact |
| applname | sp_scan_xact sp_start_xact |
| xactname | sp_scan_xact sp_start_xact |
| password | sp_abort_xact sp_commit_xact sp_remove_xact sp_start_xact |
| QUERIES | |
| Joined With | Links |
| DEPENDENCIES |
| READERS AND WRITERS written by proc sybsystemprocs..sp_start_xact read_written by proc sybsystemprocs..sp_commit_xact read_written by proc sybsystemprocs..sp_remove_xact read by proc sybsystemprocs..sp_stat_xact read_written by proc sybsystemprocs..sp_abort_xact read by proc sybsystemprocs..sp_scan_xact |