Database	Table	Application	Created	Links
master	systypes		31 Aug 14	Joins Schema ColumnUsage Queries Dependencies

1     create table systypes(-- 49 Rows, Data: 4 KB, Index: 16 KB
2         uid int not null,
3         usertype smallint not null,
4         variable bit not null,
5         allownulls bit not null,
6         type tinyint not null,
7         length int not null,
8         tdefault int not null,
9         domain int not null,
10        name longsysname(255) not null,
11        printfmt varchar(255) null,
12        prec tinyint null,
13        scale tinyint null,
14        ident tinyint null,
15        hierarchy tinyint null,
16        xtypeid int null,
17        xdbid int null,
18        accessrule int null
19    )
20    
21    create unique clustered index csystypes on systypes(-- 6 KB refcount: 1
22        name
23    )
24    create unique index ncsystypes on systypes(-- 6 KB refcount: 0
25        usertype
26    )
27    
28    alter table systypes lock datarows
29    
30    Grant Select on systypes to public
31    

SCHEMA

DEPENDENCIES

READERS AND WRITERS read by proc sybsystemprocs..sp_aux_encr_verify_downgrade   read by proc sybsystemprocs..sp_autoformat      called by proc sybsystemprocs..sp_remoteoption      called by proc sybsystemprocs..sp_helpexternlogin      called by proc sybsystemprocs..sp_help_resource_limit      called by proc sybsystemprocs..sp_helpcomputedcolumn         called by proc sybsystemprocs..sp_help         called by proc sybsystemprocs..sp_helpindex            called by proc sybsystemprocs..sp_help      called by proc sybsystemprocs..sp_replication_path      called by proc sybsystemprocs..sp_ddlgen_database      called by proc sybsystemprocs..sp_spaceusage_object_genoutput         called by proc sybsystemprocs..sp_spaceusage_object            called by proc sybsystemprocs..sp_spaceusage      called by proc sybsystemprocs..sp_helpapptrace      called by proc sybsystemprocs..sp_pkeys      called by proc sybsystemprocs..sp_addthreshold      called by proc sybsystemprocs..sp_securityprofile      called by proc sybsystemprocs..sp_setreptable      called by proc sybsystemprocs..sp_monitor_list      called by proc sybsystemprocs..sp_helpkey         called by proc sybsystemprocs..sp_help      called by proc sybsystemprocs..sp_cacheconfig         called by proc sybsystemprocs..sp_do_poolconfig            called by proc sybsystemprocs..sp_poolconfig      called by proc sybsystemprocs..sp_passwordpolicy         called by proc sybsystemprocs..sp_downgrade      called by proc sybsystemprocs..sp_helpcache      called by proc sybsystemprocs..sp_dbrecovery_order      called by proc sybsystemprocs..sp_setrepcol      called by proc sybsystemprocs..sp_help_qplan         called by proc sybsystemprocs..sp_cmp_all_qplans      called by proc sybsystemprocs..sp_helpserver      called by proc sybsystemprocs..sp_helpextendedproc      called by proc sybsystemprocs..sp_helprotect      called by proc sybsystemprocs..sp_helpjoins      called by proc sybsystemprocs..sp_version      called by proc sybsystemprocs..sp_help_rep_agent      called by proc sybsystemprocs..sp_options      called by proc sybsystemprocs..sp_monitor_procedure      called by proc sybsystemprocs..sp_help_params         called by proc sybsystemprocs..sp_help         called by proc sybsystemprocs..sp_showtext_sproc_tagline            called by proc sybsystemprocs..sp_showtext_output               called by proc sybsystemprocs..sp_showtext                  called by proc sybsystemprocs..sp_helptext                  called by proc sybsystemprocs..sp_helptext_usage                     called by proc sybsystemprocs..sp_helptext      called by proc sybsystemprocs..sp_aux_computeprivs         called by proc sybsystemprocs..sp_column_privileges         called by proc sybsystemprocs..sp_table_privileges      called by proc sybsystemprocs..sp_monitor_list_montypes         called by proc sybsystemprocs..sp_monitor_list      called by proc sybsystemprocs..sp_monitor_procstack      called by proc sybsystemprocs..sp_helpdevice      called by proc sybsystemprocs..sp_helpconfig      called by proc sybsystemprocs..sp_spaceused      called by proc sybsystemprocs..sp_monitor_statement      called by proc sybsystemprocs..sp_encryption         called by proc sybsystemprocs..sp_downgrade      called by proc sybsystemprocs..sp_setreplicate      called by proc sybsystemprocs..sp_helpjava      called by proc sybsystemprocs..sp_autoformat      called by proc sybsystemprocs..sp_column_privileges      called by proc sybsystemprocs..sp_config_rep_agent      called by proc sybsystemprocs..sp_droplogin      called by proc sybsystemprocs..sp_indsuspect      called by proc sybsystemprocs..sp_configure         called by proc sybsystemprocs..sp_configure         called by proc sybsystemprocs..sp_setlockpromote            called by proc sybsystemprocs..sp_setrowlockpromote            called by proc sybsystemprocs..sp_setpglockpromote      called by proc sybsystemprocs..sp_estspace      called by proc sybsystemprocs..sp_helpthread      called by proc sybsystemprocs..sp_helpconstraint      called by proc sybsystemprocs..sp_fkeys      called by proc sybsystemprocs..sp_helpgroup         called by proc sybsystemprocs..sp_helpuser      called by proc sybsystemprocs..sp_helpsegment      called by proc sybsystemprocs..sp_monitor_connection      called by proc sybsystemprocs..sp_dboption_flmode         called by proc sybsystemprocs..sp_dboption      called by proc sybsystemprocs..sp_who      called by proc sybsystemprocs..sp_displaylogin      called by proc sybsystemprocs..sp_helpindex      called by proc sybsystemprocs..sp_helpmaplogin      called by proc sybsystemprocs..sp_showcontrolinfo      called by proc sybsystemprocs..sp_helpdb      called by proc sybsystemprocs..sp_spaceusage_tranlog_genoutput         called by proc sybsystemprocs..sp_spaceusage_tranlog            called by proc sybsystemprocs..sp_spaceusage      called by proc sybsystemprocs..sp_help      called by proc sybsystemprocs..sp_help_qpgroup      called by proc sybsystemprocs..sp_lookup      called by proc sybsystemprocs..sp_logintrigger         called by proc sybsystemprocs..sp_modifylogin      called by proc sybsystemprocs..sp_helpthreshold      called by proc sybsystemprocs..sp_helplanguage      called by proc sybsystemprocs..sp_multdb_show         called by proc sybsystemprocs..sp_tempdb      called by proc sybsystemprocs..sp_objectsegment      called by proc sybsystemprocs..sp_ijdbc_aux_computeprivs      called by proc sybsystemprocs..sp_helpobjectdef      called by proc sybsystemprocs..sp_monitor_deadlock_count_by         called by proc sybsystemprocs..sp_monitor_deadlock            called by proc sybsystemprocs..sp_monitor      called by proc sybsystemprocs..sp_helpuser      called by proc sybsystemprocs..sp_setrepproc      called by proc sybsystemprocs..sp_depends      called by proc sybsystemprocs..sp_helpremotelogin      called by proc sybsystemprocs..sp_helpartition         called by proc sybsystemprocs..sp_help      called by proc sybsystemprocs..sp_downgrade      called by proc sybsystemprocs..sp_monitor_event