DatabaseTableApplicationCreatedLinks
sybsystemdbspt_committab  31 Aug 14Joins 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_ALIASspt_committab
84

SCHEMA

COLUMN USAGE
commidsp_abort_xact  sp_commit_xact  sp_remove_xact  sp_scan_xact  sp_start_xact  sp_stat_xact 
suidsp_start_xact 
startsp_scan_xact  sp_start_xact 
lastchangesp_abort_xact  sp_commit_xact  sp_remove_xact  sp_scan_xact  sp_start_xact 
totnumsp_scan_xact  sp_start_xact 
outnumsp_remove_xact  sp_scan_xact  sp_start_xact 
heursp_start_xact 
statussp_abort_xact  sp_commit_xact  sp_scan_xact  sp_start_xact  sp_stat_xact 
xidsp_start_xact 
applnamesp_scan_xact  sp_start_xact 
xactnamesp_scan_xact  sp_start_xact 
passwordsp_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