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

1     create table sysdatabases(-- 5 Rows, Data: 2 KB, Index: 6 KB
2         name sysname not null,
3         dbid smallint not null,
4         suid int not null,
5         status smallint not null,
6         version smallint not null,
7         logptr int not null,
8         crdate datetime not null,
9         dumptrdate datetime not null,
10        status2 smallint null,
11        audflags int null,
12        deftabaud int null,
13        defvwaud int null,
14        defpraud int null,
15        def_remote_type smallint null,
16        def_remote_loc varchar(349) null,
17        status3 int null,
18        status4 int null,
19        audflags2 varbinary(16) null,
20        spare tinyint null,
21        durability int null,
22        lobcomp_lvl tinyint null,
23        inrowlen smallint null,
24        dcompdefaultlevel tinyint null
25    )
26    
27    create unique clustered index cdatabases on sysdatabases(-- 2 KB refcount: 83
28        name
29    )
30    create unique index ncsysdatabases on sysdatabases(-- 2 KB refcount: 72
31        dbid
32    )
33    
34    alter table sysdatabases lock datarows
35    
36    Grant Select on sysdatabases to public
37    Grant Select on sysdatabases to sso_role
38    

SCHEMA

DEPENDENCIES

READERS AND WRITERS read by proc sybsystemprocs..sp_ijdbc_getcatalogs   read by proc sybsystemprocs..sp_multdb_removefromgroup      called by proc sybsystemprocs..sp_tempdb   read by proc sybsystemprocs..sp_help_rep_agent   read by proc sybsystemprocs..sp_addlogin   read by proc sybsystemprocs..sp_oledb_statistics   read by proc sybsystemprocs..sp_jdbc_getcatalogs   read by proc sybsystemprocs..sp_rebuild_text   read by proc sybsystemprocs..sp_addsegment   read by proc sybsystemprocs..sp_addtype   read_written by proc sybsystemprocs..sp_changedbowner   read by proc sybsystemprocs..sp_config_rep_agent   read by proc sybsystemprocs..sp_logdevice   read by proc sybsystemprocs..sp_dropserver   read by proc sybsystemprocs..sp_sysmon_repagent      called by proc sybsystemprocs..sp_sysmon_analyze         called by proc sybsystemprocs..sp_sysmon   read by proc sybsystemprocs..sp_reptostandby   read by proc sybsystemprocs..sp_lookup   read by proc sybsystemprocs..sp_merge_dup_inline_default   read by proc sybsystemprocs..sp_setlockpromote      called by proc sybsystemprocs..sp_setpglockpromote      called by proc sybsystemprocs..sp_setrowlockpromote   read by proc sybsystemprocs..sp_multdb_addtogroup      called by proc sybsystemprocs..sp_tempdb   read by proc sybsystemprocs..sp_helpcache   read by proc sybsystemprocs..sp_multdb_bind      called by proc sybsystemprocs..sp_tempdb   read by proc sybsystemprocs..sp_spaceused   read_written by proc sybsystemprocs..sp_renamedb   read by proc sybsystemprocs..sp_dropsegment   read by proc sybsystemprocs..sp_helpsegment   read by proc sybsystemprocs..sp_droplogin   read by proc sybsystemprocs..sp_oledb_tables   read by proc sybsystemprocs..sp_checkreswords   read by proc sybsystemprocs..sp_helpdb   read by proc sybsystemprocs..sp_opt_querystats_main      called by proc sybsystemprocs..sp_opt_querystats   read by proc sybsystemprocs..sp_dropdevice   read by proc sybsystemprocs..sp_odbc_databases   read by proc sybsystemprocs..sp_multdb_show      called by proc sybsystemprocs..sp_tempdb   read by proc sybsystemprocs..sp_dbrecovery_order   read by proc sybsystemprocs..sp_opt_querystats   read by proc sybsystemprocs..sp_extendsegment   read by proc sybsystemprocs..sp_dboption_flmode      called by proc sybsystemprocs..sp_dboption   read by proc sybsystemprocs..sp_optimal_text_space      called by proc sybsystemprocs..sp_chgattribute   read by proc sybsystemprocs..sp_droplockpromote      called by proc sybsystemprocs..sp_dropglockpromote      called by proc sybsystemprocs..sp_droprowlockpromote   read by proc sybsystemprocs..sp_logiosize   read by proc sybsystemprocs..sp_setrepdbmode   read by proc sybsystemprocs..sp_spaceusage_tranlog_init      called by proc sybsystemprocs..sp_spaceusage_tranlog         called by proc sybsystemprocs..sp_spaceusage   read by proc sybsystemprocs..sp_databases   read by proc sybsystemprocs..sp_start_rep_agent   read_written by proc sybsystemprocs..sp_defaultloc   read by proc sybsystemprocs..sp_bindcache      called by proc sybsystemprocs..sp_unbindcache   read by proc sybsystemprocs..sp_drv_bcpmetadata   read by proc sybsystemprocs..sp_oledb_databases   read by proc sybsystemprocs..sp_downgrade_sysobjects      called by proc sybsystemprocs..sp_downgrade   read by proc sybsystemprocs..sp_checknames   read by proc sybsystemprocs..sp_multdb_unbindall_db      called by proc sybsystemprocs..sp_tempdb   read by proc sybsystemprocs..sp_chgattribute   read by proc sybsystemprocs..sp_spaceusage_object      called by proc sybsystemprocs..sp_spaceusage   written by proc sybsystemprocs..sp_setsuspect_granularity   read by proc sybsystemprocs..sp_ddlgen_permissions   read by proc sybsystemprocs..sp_jdbc_getcatalogs_cts   read by proc sybsystemprocs..sp_post_xpload   read by proc sybsystemprocs..sp_dbremap   read by proc sybsystemprocs..sp_makesuspect_obj   read_written by proc sybsystemprocs..sp_downgrade   read by proc sybsystemprocs..sp_setsuspect_error   read by proc sybsystemprocs..sp_tables   read by proc sybsystemprocs..sp_spaceusage_tranlog   read by proc sybsystemprocs..sp_dropuser   read by proc sybsystemprocs..sp_replication_path   read by proc sybsystemprocs..sp_defaultdb      called by proc sybsystemprocs..sp_modifylogin   read by proc sybsystemprocs..sp_encryption      called by proc sybsystemprocs..sp_downgrade   read by proc sybsystemprocs..sp_fixindex   read by proc sybsystemprocs..sp_is_valid_user      called by proc sybsystemprocs..sp_optimal_text_space      called by proc sybsystemprocs..sp_plan_dbccdb   read by proc sybsystemprocs..sp_aux_encr_verify_downgrade   read by proc sybsystemprocs..sp_monitor_archive      called by proc sybsystemprocs..sp_monitor_deadlock         called by proc sybsystemprocs..sp_monitor   read by proc sybsystemprocs..sp_cachestrategy   read by proc sybsystemprocs..sp_plan_dbccdb   read by proc sybsystemprocs..sp_ddlgen_database   read by proc sybsystemprocs..sp_oledb_views   read by proc sybsystemprocs..sp_stop_rep_agent   read_written by proc sybsystemprocs..sp_dboption   read by proc sybsystemprocs..sp_transactions   read by proc sybsystemprocs..sp_odbc_tables