Database	Table	Application	Created	Links
tempdb	sysobjects		31 Aug 14	Joins Schema ColumnUsage Queries Dependencies

1     create table sysobjects(-- 30 Rows, Data: 4 KB, Index: 16 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(-- 6 KB refcount: 1
32        id
33    )
34    create unique index ncsysobjects on sysobjects(-- 6 KB refcount: 17
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    

SCHEMA

DEPENDENCIES

READERS AND WRITERS read by proc sybsystemprocs..sp_monitor_crt_mon_config      called by proc sybsystemprocs..sp_monitor_enable   read by proc sybsystemprocs..sp_opt_querystats_main      called by proc sybsystemprocs..sp_opt_querystats   read by proc sybsystemprocs..sp_sysmon_collect_mda      called by proc sybsystemprocs..sp_sysmon_collect         called by proc sybsystemprocs..sp_sysmon   read by proc sybsystemprocs..sp_sysmon_collect   read by proc sybsystemprocs..sp_monitor_enable   read by proc sybsystemprocs..sp_ha_check_certified      called by proc sybsystemprocs..sp_locklogin         called by proc sybsystemprocs..sp_addlogin         called by proc sybsystemprocs..sp_droplogin      called by proc sybsystemprocs..sp_addtype      called by proc sybsystemprocs..sp_addremotelogin      called by proc sybsystemprocs..sp_addlogin      called by proc sybsystemprocs..sp_remoteoption      called by proc sybsystemprocs..sp_password         called by proc sybsystemprocs..sp_addlogin      called by proc sybsystemprocs..sp_addalias      called by proc sybsystemprocs..sp_addexternlogin      called by proc sybsystemprocs..sp_dboption_flmode         called by proc sybsystemprocs..sp_dboption      called by proc sybsystemprocs..sp_update_authmech_value      called by proc sybsystemprocs..sp_modify_time_range      called by proc sybsystemprocs..sp_addlanguage      called by proc sybsystemprocs..sp_drop_time_range      called by proc sybsystemprocs..sp_droptype      called by proc sybsystemprocs..sp_changegroup      called by proc sybsystemprocs..sp_maplogin      called by proc sybsystemprocs..sp_modify_resource_limit      called by proc sybsystemprocs..sp_dropserver      called by proc sybsystemprocs..sp_dropalias      called by proc sybsystemprocs..sp_modifylogin      called by proc sybsystemprocs..sp_drop_resource_limit      called by proc sybsystemprocs..sp_adduser      called by proc sybsystemprocs..sp_renamedb      called by proc sybsystemprocs..sp_setlangalias      called by proc sybsystemprocs..sp_droplanguage      called by proc sybsystemprocs..sp_dropuser      called by proc sybsystemprocs..sp_passwordpolicy         called by proc sybsystemprocs..sp_downgrade      called by proc sybsystemprocs..sp_logintrigger         called by proc sybsystemprocs..sp_modifylogin      called by proc sybsystemprocs..sp_droplogin      called by proc sybsystemprocs..sp_defaultdb         called by proc sybsystemprocs..sp_modifylogin      called by proc sybsystemprocs..sp_addserver      called by proc sybsystemprocs..sp_add_time_range      called by proc sybsystemprocs..sp_serveroption      called by proc sybsystemprocs..sp_defaultlanguage         called by proc sybsystemprocs..sp_modifylogin      called by proc sybsystemprocs..sp_add_resource_limit      called by proc sybsystemprocs..sp_dropexternlogin      called by proc sybsystemprocs..sp_changedbowner      called by proc sybsystemprocs..sp_addgroup      called by proc sybsystemprocs..sp_dropgroup   read by proc sybsystemprocs..sp_object_stats