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

1     create table syscolumns(-- 1.9 KRows, Data: 186 KB, Index: 250 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    create unique clustered index csyscolumns on syscolumns(-- 64 KB refcount: 270
35        id, number, colid
36    )
37    
38    alter table syscolumns lock datarows
39    
40    Grant Select on syscolumns to public
41    

SCHEMA

DEPENDENCIES

READERS AND WRITERS read by proc sybsystemprocs..sp_estspace   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_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   read by proc sybsystemprocs..sp_setrepcol   read by proc sybsystemprocs..sp_oledb_datatype_info   read by proc sybsystemprocs..sp_statistics   read by proc sybsystemprocs..sp_columns   read by proc sybsystemprocs..sp_drv_bcpmetadata   read_written by proc sybsystemprocs..sp_setreplicate   read by proc sybsystemprocs..sp_help   written by proc sybsystemprocs..sp_merge_dup_inline_default   read by proc sybsystemprocs..sp_ijdbc_getversioncolumns   read by proc sybsystemprocs..sp_oledb_getprocedurecolumns   read by proc sybsystemprocs..sp_helpconstraint   read by proc sybsystemprocs..sp_aux_computeprivs      called by proc sybsystemprocs..sp_column_privileges      called by proc sybsystemprocs..sp_table_privileges   read by proc sybsystemprocs..sp_oledb_columns   read by proc sybsystemprocs..sp_odbc_getcolumnprivileges   read by proc sybsystemprocs..sp_setlangalias   read by proc sybsystemprocs..sp_jdbc_getindexinfo   read by proc sybsystemprocs..sp_adduser   read by proc sybsystemprocs..sp_odbc_getversioncolumns   read_written by proc sybsystemprocs..sp_bindefault   read by proc sybsystemprocs..sp_jdbc_getversioncolumns   read by proc sybsystemprocs..sp_jdbc_getbestrowidentifier   read by proc sybsystemprocs..sp_spaceusage_object_populate   read by proc sybsystemprocs..sp_ijdbc_columns   read by proc sybsystemprocs..sp_ijdbc_getindexinfo   read by proc sybsystemprocs..sp_column_privileges   read by proc sybsystemprocs..sp_ijdbc_getprocedurecolumns   read by proc sybsystemprocs..sp_helpextendedproc   read by proc sybsystemprocs..sp_ijdbc_getbestrowidentifier   read by proc sybsystemprocs..sp_droptype   read by proc sybsystemprocs..sp_jdbc_computeprivs      called by proc sybsystemprocs..sp_jdbc_gettableprivileges   read by proc sybsystemprocs..sp_addobjectdef      called by proc sybsystemprocs..sp_addtabledef   read by proc sybsystemprocs..sp_helpcomputedcolumn      called by proc sybsystemprocs..sp_help      called by proc sybsystemprocs..sp_helpindex         called by proc sybsystemprocs..sp_help   read by proc sybsystemprocs..sp_helpjava   read by proc sybsystemprocs..sp_changegroup   read by proc sybsystemprocs..sp_ijdbc_aux_computeprivs   read by proc sybsystemprocs..sp_commonkey   read by proc sybsystemprocs..sp_helpartition      called by proc sybsystemprocs..sp_help   read by proc sybsystemprocs..sp_helpobjectdef   read by proc sybsystemprocs..sp_checkreswords   read by proc sybsystemprocs..sp_modifystats   read by proc sybsystemprocs..sp_jdbc_getcolumnprivileges   read by proc sybsystemprocs..sp_dropextendedproc   read by proc sybsystemprocs..sp_addtype   read by proc sybsystemprocs..sp_chgattribute   read by proc sybsystemprocs..sp_jdbc_columns   read_written by proc sybsystemprocs..sp_unbindefault   read by proc sybsystemprocs..sp_jdbc_getfunctioncolumns   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_oledb_primarykey   read by proc sybsystemprocs..sp_depends   read by proc sybsystemprocs..sp_checknames   read by proc sybsystemprocs..sp_primarykey   read by proc sybsystemprocs..sp_foreignkey   read by proc sybsystemprocs..sp_downgrade   read by proc sybsystemprocs..sp_oledb_getcolumnprivileges   read by proc sybsystemprocs..sp_encryption      called by proc sybsystemprocs..sp_downgrade   written by proc sybsystemprocs..sp_setreptable   read by proc sybsystemprocs..sp_addgroup   read_written by proc sybsystemprocs..sp_bindrule   read by proc sybsystemprocs..sp_special_columns   read by proc sybsystemprocs..sp_dropuser   read by proc sybsystemprocs..sp_odbc_columns   read_written by proc sybsystemprocs..sp_unbindrule   read by proc sybsystemprocs..sp_helpjoins   read by proc sybsystemprocs..sp_post_xpload   read by proc sybsystemprocs..sp_odbc_getprocedurecolumns   read by proc sybsystemprocs..sp_helprotect   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_rename   read by proc sybsystemprocs..sp_addsegment   read by proc sybsystemprocs..sp_aux_encr_verify_downgrade   read by proc sybsystemprocs..sp_odbc_getindexinfo   read by proc sybsystemprocs..sp_ijdbc_getcolumnprivileges   read by proc sybsystemprocs..sp_sproc_columns   read by proc sybsystemprocs..sp_depends_cols      called by proc sybsystemprocs..sp_depends   read by proc sybsystemprocs..sp_setrepproc