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

1     create table sysobjects(-- 655 Rows, Data: 82 KB, Index: 128 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    create unique clustered index csysobjects on sysobjects(-- 20 KB refcount: 404
31        id
32    )
33    create unique index ncsysobjects on sysobjects(-- 26 KB refcount: 233
34        name, uid
35    )
36    
37    alter table sysobjects lock datarows
38    
39    Grant Select on sysobjects to public
40    Grant Select on sysobjects to sso_role
41    

SCHEMA

DEPENDENCIES

READERS AND WRITERS read by proc sybsystemprocs..sp_odbc_tables   read by proc sybsystemprocs..sp_replication_path   read by proc sybsystemprocs..sp_helpconstraint   read by proc sybsystemprocs..sp_aux_encrkey_lookup   read by proc sybsystemprocs..sp_recompile   read by proc sybsystemprocs..sp_odbc_getindexinfo   read by proc sybsystemprocs..sp_dropsegment   read_written by proc sybsystemprocs..sp_setreplicate   read by proc sybsystemprocs..sp_drop_object   read by proc sybsystemprocs..sp_oledb_statistics   read by proc sybsystemprocs..sp_stored_procedures   read by proc sybsystemprocs..sp_helpindex      called by proc sybsystemprocs..sp_help   read by proc sybsystemprocs..sp_setup_table_transfer   read by proc sybsystemprocs..sp_oledb_getprocedurecolumns   read by proc sybsystemprocs..sp_jdbc_getfunctioncolumns   read by proc sybsystemprocs..sp_dcachestats_obj_details   read_written by proc sybsystemprocs..sp_unbindrule   read by proc sybsystemprocs..sp_dropalias   read by proc sybsystemprocs..sp_help   read by proc sybsystemprocs..sp_dropuser   read by proc sybsystemprocs..sp_fkeys   read by proc sybsystemprocs..sp_ijdbc_primarykey   read by proc sybsystemprocs..sp_spaceused   read by proc sybsystemprocs..sp_oledb_stored_procedures   read by proc sybsystemprocs..sp_aux_encr_verify_downgrade   read by proc sybsystemprocs..sp_aux_get_concrtlyownedobj   read by proc sybsystemprocs..sp_tab_suspectptn   read by proc sybsystemprocs..sp_depends_cols      called by proc sybsystemprocs..sp_depends   read by proc sybsystemprocs..sp_odbc_stored_procedures   read by proc sybsystemprocs..sp_ijdbc_getbestrowidentifier   read by proc sybsystemprocs..sp_aux_computeprivs      called by proc sybsystemprocs..sp_table_privileges      called by proc sybsystemprocs..sp_column_privileges   read by proc sybsystemprocs..sp_flushstats   read by proc sybsystemprocs..sp_downgrade   read by proc sybsystemprocs..sp_statistics   read by proc sybsystemprocs..sp_ijdbc_aux_computeprivs   read by proc sybsystemprocs..sp_checknames   read by proc sybsystemprocs..sp_droptype   read by proc sybsystemprocs..sp_procxmode   read by proc sybsystemprocs..sp_oledb_gettableprivileges   read by proc sybsystemprocs..sp_ijdbc_columns   read by proc sybsystemprocs..sp_oledb_computeprivs      called by proc sybsystemprocs..sp_oledb_getcolumnprivileges      called by proc sybsystemprocs..sp_oledb_gettableprivileges   read_written by proc sybsystemprocs..sp_merge_dup_inline_default   read by proc sybsystemprocs..sp_checkreswords   read by proc sybsystemprocs..sp_index_row_size_est      called by proc sybsystemprocs..sp_spaceusage_object_populate         called by proc sybsystemprocs..sp_spaceusage_object            called by proc sybsystemprocs..sp_spaceusage   read by proc sybsystemprocs..sp_monitor   read by proc sybsystemprocs..sp_ijdbc_getcolumnprivileges   read_written by proc sybsystemprocs..sp_setrepdefmode   read by proc sybsystemprocs..sp_tables   read by proc sybsystemprocs..sp_estspace   read by proc sybsystemprocs..sp_foreignkey   read by proc sybsystemprocs..sp_helpthreshold   read by proc sybsystemprocs..sp_unbindefault   read by proc sybsystemprocs..sp_helpartition      called by proc sybsystemprocs..sp_help   read_written by proc sybsystemprocs..sp_optimal_text_space      called by proc sybsystemprocs..sp_chgattribute   read by proc sybsystemprocs..sp_indsuspect   read_written by proc sybsystemprocs..sp_setreptable   read_written by proc sybsystemprocs..sp_rename   read by proc sybsystemprocs..sp_oledb_tables   read by proc sybsystemprocs..sp_setlockpromote      called by proc sybsystemprocs..sp_setrowlockpromote      called by proc sybsystemprocs..sp_setpglockpromote   read by proc sybsystemprocs..sp_odbc_getprocedurecolumns   read by proc sybsystemprocs..sp_oledb_fkeys   read by proc sybsystemprocs..sp_helpjava   read by proc sybsystemprocs..sp_ijdbc_getversioncolumns   read_written by proc sybsystemprocs..sp_chgattribute   read by proc sybsystemprocs..sp_modifythreshold   read by proc sybsystemprocs..sp_ijdbc_gettableprivileges   read_written by proc sybsystemprocs..sp_fixindex   read by proc sybsystemprocs..sp_unbindmsg   read by proc sybsystemprocs..sp_helpkey      called by proc sybsystemprocs..sp_help   read_written by proc sybsystemprocs..sp_markreport   read by proc sybsystemprocs..sp_jdbc_tables   read by proc sybsystemprocs..sp_primarykey   read by proc sybsystemprocs..sp_bindexeclass   read by proc sybsystemprocs..sp_droplockpromote      called by proc sybsystemprocs..sp_dropglockpromote      called by proc sybsystemprocs..sp_droprowlockpromote   read by proc sybsystemprocs..sp_objectsegment   read by proc sybsystemprocs..sp_ijdbc_getprocedurecolumns   read by proc sybsystemprocs..sp_helpextendedproc   read by proc sybsystemprocs..sp_jdbc_gettableprivileges   read by proc sybsystemprocs..sp_odbc_columns   read by proc sybsystemprocs..sp_modifystats   read by proc sybsystemprocs..sp_addthreshold   read by proc sybsystemprocs..sp_odbc_getcolumnprivileges   read by proc sybsystemprocs..sp_odbc_primarykey   read by proc sybsystemprocs..sp_aux_parse_entity      called by proc sybsystemprocs..sp_cachestrategy      called by proc sybsystemprocs..sp_bindcache         called by proc sybsystemprocs..sp_unbindcache   read by proc sybsystemprocs..sp_jdbc_getversioncolumns   read by proc sybsystemprocs..sp_jdbc_getbestrowidentifier   read by proc sybsystemprocs..sp_helprotect   read by proc sybsystemprocs..sp_helpcomputedcolumn      called by proc sybsystemprocs..sp_helpindex      called by proc sybsystemprocs..sp_help   read by proc sybsystemprocs..sp_dropkey   read by proc sybsystemprocs..sp_dropthreshold   read by proc sybsystemprocs..sp_column_privileges   read by proc sybsystemprocs..sp_dropobjectdef      called by proc sybsystemprocs..sp_droptabledef   read by proc sybsystemprocs..sp_helpjoins   read by proc sybsystemprocs..sp_columns   read by proc sybsystemprocs..sp_ijdbc_getindexinfo   read by proc sybsystemprocs..sp_dbxt_recreate_proc   read by proc sybsystemprocs..sp_ijdbc_stored_procedures   read by proc sybsystemprocs..sp_freedll   read by proc sybsystemprocs..sp_jdbc_fkeys      called by proc sybsystemprocs..sp_jdbc_getcrossreferences      called by proc sybsystemprocs..sp_jdbc_importkey      called by proc sybsystemprocs..sp_jdbc_exportkey   read by proc sybsystemprocs..sp_drv_bcpmetadata   read by proc sybsystemprocs..sp_sysmon_collect      called by proc sybsystemprocs..sp_sysmon   read by proc sybsystemprocs..sp_encryption      called by proc sybsystemprocs..sp_downgrade   read by proc sybsystemprocs..sp_pkeys   read by proc sybsystemprocs..sp_spaceusage_object_init      called by proc sybsystemprocs..sp_spaceusage_object   read by proc sybsystemprocs..sp_unbindexeclass   read by proc sybsystemprocs..sp_oledb_columns   read by proc sybsystemprocs..sp_jdbc_columns   read by proc sybsystemprocs..sp_odbc_gettableprivileges   read by proc sybsystemprocs..sp_remap   read by proc sybsystemprocs..sp_helptext   read by proc sybsystemprocs..sp_addmessage   read by proc sybsystemprocs..sp_lookup   read by proc sybsystemprocs..sp_ijdbc_fkeys      called by proc sybsystemprocs..sp_ijdbc_getcrossreferences      called by proc sybsystemprocs..sp_ijdbc_importkey      called by proc sybsystemprocs..sp_ijdbc_exportkey   read by proc sybsystemprocs..sp_commonkey   read by proc sybsystemprocs..sp_oledb_primarykey   read by proc sybsystemprocs..sp_helpuser   read by proc sybsystemprocs..sp_jdbc_primarykey   read_written by proc sybsystemprocs..sp_setrepproc   read by proc sybsystemprocs..sp_jdbc_getcolumnprivileges   read by proc sybsystemprocs..sp_placeobject   read by proc sybsystemprocs..sp_oledb_views   read by proc sybsystemprocs..sp_bindmsg   read by proc sybsystemprocs..sp_ijdbc_tables   read by proc sybsystemprocs..sp_addobjectdef      called by proc sybsystemprocs..sp_addtabledef   read by proc sybsystemprocs..sp_odbc_computeprivs      called by proc sybsystemprocs..sp_odbc_getcolumnprivileges      called by proc sybsystemprocs..sp_odbc_gettableprivileges   read by proc sybsystemprocs..sp_bindefault   read by proc sybsystemprocs..sp_depends   read by proc sybsystemprocs..sp_post_xpload   read by proc sybsystemprocs..sp_monitor_procedure   read by proc sybsystemprocs..sp_odbc_fkeys   read by proc sybsystemprocs..sp_sysmon   read by proc sybsystemprocs..sp_oledb_getcolumnprivileges   read by proc sybsystemprocs..sp_table_privileges   read by proc sybsystemprocs..sp_jdbc_computeprivs      called by proc sybsystemprocs..sp_jdbc_gettableprivileges   read by proc sybsystemprocs..sp_dropgroup   read by proc sybsystemprocs..sp_showtext      called by proc sybsystemprocs..sp_helptext_usage         called by proc sybsystemprocs..sp_helptext      called by proc sybsystemprocs..sp_helptext   read by proc sybsystemprocs..sp_sproc_columns   read by proc sybsystemprocs..sp_spaceusage_runcmd      called by proc sybsystemprocs..sp_spaceusage   read by proc sybsystemprocs..sp_jdbc_stored_procedures   read by proc sybsystemprocs..sp_jdbc_getindexinfo   read by proc sybsystemprocs..sp_setrepcol   read by proc sybsystemprocs..sp_aux_encrkey_info   read_written by proc sybsystemprocs..sp_bindrule