DatabaseTableApplicationCreatedLinks
mastersysobjects  31 Aug 14Joins Schema ColumnUsage Queries Dependencies

1     create table sysobjects(-- 174 Rows, Data: 22 KB, Index: 38 KB
2         name longsysname(255) not null,
3         id int not null,
4         uid int not null,
5         type char(2) not null,
6         userstat smallint not null,
7         sysstat smallint not null,
8         indexdel smallint not null,
9         schemacnt smallint not null,
10        sysstat2 int not null,
11        crdate datetime not null,
12        expdate datetime not null,
13        deltrig int not null,
14        instrig int not null,
15        updtrig int not null,
16        seltrig int not null,
17        ckfirst int not null,
18        cache smallint not null,
19        audflags int null,
20        objspare usmallint not null,
21        versionts binary(12) null,
22        loginame varchar(30) null,
23        identburnmax numeric(38, 0) null,
24        spacestate smallint null,
25        erlchgts binary(8) null,
26        sysstat3 usmallint not null,
27        lobcomp_lvl tinyint null
28    )
29    
30    
31    create unique clustered index csysobjects on sysobjects(-- 8 KB refcount: 0
32        id
33    )
34    create unique index ncsysobjects on sysobjects(-- 8 KB refcount: 3
35        name, uid
36    )
37    
38    alter table sysobjects lock datarows
39    
40    Grant Select on sysobjects to public
41    Grant Select on sysobjects to sso_role
42    
Estimated Index Usage
sysobjects.ncsysobjects unique(name, uid)3
sysobjects.csysobjects unique clustered(id)0

ALIASES USED for master..sysobjects
NO_ALIASo
23

SCHEMA

COLUMN USAGE
namesp_droplogin  sp_monitor_deadlock_count_by  sp_monitor_verify_setup  sp_mon_gen_columnlist 
idsp_mon_gen_columnlist 
uidsp_mon_gen_columnlist 
crdatesp_monitor_deadlock_count_by 

QUERIES
Joined With Links

DEPENDENCIES
READERS AND WRITERS
read by proc sybsystemprocs..sp_monitor_verify_setup  
   called by proc sybsystemprocs..sp_monitor_archive  
      called by proc sybsystemprocs..sp_monitor_deadlock  
         called by proc sybsystemprocs..sp_monitor  
   called by proc sybsystemprocs..sp_monitor_statement  
   called by proc sybsystemprocs..sp_monitor_event  
   called by proc sybsystemprocs..sp_monitor_deadlock  
   called by proc sybsystemprocs..sp_monitor_list_montypes  
      called by proc sybsystemprocs..sp_monitor_list  
   called by proc sybsystemprocs..sp_monitor_disable  
   called by proc sybsystemprocs..sp_monitor_procedure  
   called by proc sybsystemprocs..sp_monitor_connection  
   called by proc sybsystemprocs..sp_monitor_enable  
read by proc sybsystemprocs..sp_mon_gen_columnlist  
   called by proc sybsystemprocs..sp_mon_archive_genSQL  
      called by proc sybsystemprocs..sp_monitor_deadlock  
      called by proc sybsystemprocs..sp_mon_archive_monTable  
         called by proc sybsystemprocs..sp_mon_archive_deadlock  
read by proc sybsystemprocs..sp_droplogin  
read by proc sybsystemprocs..sp_monitor_deadlock_count_by  
   called by proc sybsystemprocs..sp_monitor_deadlock