Database	Table	Application	Created	Links
sybsystemprocs	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: 73
22        name
23    )
24    create unique index ncsystypes on systypes(-- 6 KB refcount: 60
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_ijdbc_columns   read by proc sybsystemprocs..sp_ijdbc_datatype_info   read by proc sybsystemprocs..sp_jdbc_datatype_info_cts   read by proc sybsystemprocs..sp_sproc_columns   read by proc sybsystemprocs..sp_jdbc_datatype_info   read by proc sybsystemprocs..sp_odbc_datatype_info   read by proc sybsystemprocs..sp_checknames   read by proc sybsystemprocs..sp_lookup   read_written by proc sybsystemprocs..sp_unbindefault   read_written by proc sybsystemprocs..sp_unbindrule   read by proc sybsystemprocs..sp_odbc_columns   read by proc sybsystemprocs..sp_checkreswords   read by proc sybsystemprocs..sp_jdbc_getfunctioncolumns   read by proc sybsystemprocs..sp_ijdbc_sql_type_name   read_written by proc sybsystemprocs..sp_bindrule   read_written by proc sybsystemprocs..sp_droptype   read by proc sybsystemprocs..sp_oledb_getprocedurecolumns   read by proc sybsystemprocs..sp_datatype_info   read by proc sybsystemprocs..sp_columns   read by proc sybsystemprocs..sp_setrepcol   read by proc sybsystemprocs..sp_jdbc_getversioncolumns   read by proc sybsystemprocs..sp_helpuser   read_written by proc sybsystemprocs..sp_addtype   read by proc sybsystemprocs..sp_jdbc_getbestrowidentifier   read by proc sybsystemprocs..sp_special_columns   read_written by proc sybsystemprocs..sp_rename   read by proc sybsystemprocs..sp_oledb_columns   read by proc sybsystemprocs..sp_ijdbc_getbestrowidentifier   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_odbc_getversioncolumns   read by proc sybsystemprocs..sp_dropuser   read by proc sybsystemprocs..sp_jdbc_columns   read by proc sybsystemprocs..sp_ijdbc_getversioncolumns   read_written by proc sybsystemprocs..sp_bindefault   read by proc sybsystemprocs..sp_odbc_getprocedurecolumns   read by proc sybsystemprocs..sp_jdbc_getsupertypes   read by proc sybsystemprocs..sp_help   read by proc sybsystemprocs..sp_sql_type_name   read by proc sybsystemprocs..sp_ijdbc_getprocedurecolumns   read by proc sybsystemprocs..sp_oledb_datatype_info