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

1     create table syscolumns(-- 1.4 KRows, Data: 158 KB, Index: 220 KB
2         id int not null,
3         number smallint not null,
4         colid smallint not null,
5         status tinyint not null,
6         type tinyint not null,
7         length int not null,
8         offset smallint not null,
9         usertype smallint not null,
10        cdefault int not null,
11        domain int not null,
12        name longsysname(255) not null,
13        printfmt varchar(255) null,
14        prec tinyint null,
15        scale tinyint null,
16        remote_type int null,
17        remote_name varchar(255) null,
18        xstatus int null,
19        xtype int null,
20        xdbid int null,
21        accessrule int null,
22        status2 int null,
23        status3 smallint not null,
24        computedcol int null,
25        encrtype int null,
26        encrlen int null,
27        encrkeyid int null,
28        encrkeydb sysname null,
29        encrdate datetime null,
30        lobcomp_lvl tinyint null,
31        inrowlen smallint null
32    )
33    
34    
35    create unique clustered index csyscolumns on syscolumns(-- 62 KB refcount: 15
36        id, number, colid
37    )
38    
39    alter table syscolumns lock datarows
40    
41    Grant Select on syscolumns to public
42    

SCHEMA

DEPENDENCIES

READERS AND WRITERS read by proc sybsystemprocs..sp_renamedb   read by proc sybsystemprocs..sp_addexternlogin   read by proc sybsystemprocs..sp_addlogin   read by proc sybsystemprocs..sp_spaceusage   read by proc sybsystemprocs..sp_addumpdevice   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_helplanguage      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_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_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_ijdbc_aux_computeprivs      called by proc sybsystemprocs..sp_helpdevice      called by proc sybsystemprocs..sp_helpcache      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_helpconfig      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_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_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_monitor_procedure      called by proc sybsystemprocs..sp_multdb_show         called by proc sybsystemprocs..sp_tempdb      called by proc sybsystemprocs..sp_objectsegment      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   read by proc sybsystemprocs..sp_addremotelogin   read by proc sybsystemprocs..sp_addlanguage   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_addserver