DatabaseTableApplicationCreatedLinks
sybsystemprocssysattributes  14 déc. 14Joins Schema ColumnUsage Queries Writes Propagation Dependencies

1     create table sysattributes(-- 0 Rows, Data: 2 KB, Index: 6 KB
2         class smallint not null,
3         attribute smallint not null,
4         object_type char(2) not null,
5         object_cinfo varchar(255) null,
6         object int null,
7         object_info1 int null,
8         object_info2 int null,
9         object_info3 int null,
10        int_value int null,
11        char_value varchar(768) null,
12        text_value text null,
13        image_value image null,
14        comments varchar(255) null,
15        object_cinfo2 varchar(255) null,
16        object_datetime datetimn null
17    )
18    
19    
20    create unique clustered index csysattributes on sysattributes(-- 2 KB refcount: 137
21        class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo
22    )
23    create index ncsysattributes on sysattributes(-- 2 KB refcount: 0
24        object_type, object, object_info1, object_info2, object_info3, object_cinfo, object_cinfo2, object_datetime
25    )
26    
27    alter table sysattributes lock datarows
28    
29    Grant Select on sysattributes to public
30    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[object_info1]sybsystemprocs..sysattributes[object_info1]8 Simple Join
[class, attribute]master..sysattributes[object, object_info1]4 Simple Join
[class]master..sysattributes[object]4 Simple Join
[object_info2]master..spt_values[number]3 Simple Join
[object_info1]sybsystemprocs..sysattributes[object_info2]1 Simple Join
[object_info2]sybsystemprocs..sysattributes[object_info1]1 Simple Join
[object_info1, object_info2]sybsystemprocs..syscolumns[id, colid]1 Simple Join
[object]sybsystemprocs..sysindexes[id]1 Simple Join

Estimated Index Usage
sysattributes.csysattributes unique clustered(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)137
sysattributes.ncsysattributes(object_type, object, object_info1, object_info2, object_info3, object_cinfo, object_cinfo2, object_datetime)0

ALIASES USED for sybsystemprocs..sysattributes
NO_ALIASaa1att1att2att3sysattributest
7752332204

SCHEMA

COLUMN USAGE
classsp_add_qpgroup  sp_addobjectdef  sp_aux_encr_verify_downgrade  sp_aux_get_qpgroup  sp_aux_sys_encr_passwd_lookup  sp_bindcache  sp_bindexeclass  sp_config_rep_agent  sp_drop_qpgroup  sp_droplockpromote  sp_droplockpromote_ptn  sp_dropobjectdef  sp_dropuser  sp_encryption  sp_help  sp_help_qpgroup  sp_helpindex  sp_helpobjectdef  sp_logiosize  sp_passwordpolicy  sp_rename  sp_rename_qpgroup  sp_repdbsync  sp_replication_path  sp_setlockpromote  sp_setlockpromote_ptn  sp_showcontrolinfo  sp_spaceused  sp_ssladmin  sp_unbindexeclass 
attributesp_add_qpgroup  sp_addobjectdef  sp_aux_encr_verify_downgrade  sp_aux_get_qpgroup  sp_aux_sys_encr_passwd_lookup  sp_bindcache  sp_bindexeclass  sp_config_rep_agent  sp_drop_qpgroup  sp_droplockpromote  sp_droplockpromote_ptn  sp_dropobjectdef  sp_encryption  sp_help  sp_help_qpgroup  sp_helpindex  sp_helpobjectdef  sp_logiosize  sp_rename  sp_rename_qpgroup  sp_repdbsync  sp_replication_path  sp_setlockpromote  sp_setlockpromote_ptn  sp_spaceused  sp_unbindexeclass 
object_typesp_add_qpgroup  sp_addobjectdef  sp_aux_get_qpgroup  sp_aux_sys_encr_passwd_lookup  sp_bindcache  sp_bindexeclass  sp_config_rep_agent  sp_drop_qpgroup  sp_droplockpromote  sp_droplockpromote_ptn  sp_dropuser  sp_encryption  sp_help  sp_help_qpgroup  sp_helpindex  sp_logiosize  sp_rename_qpgroup  sp_repdbsync  sp_replication_path  sp_setlockpromote  sp_setlockpromote_ptn  sp_showcontrolinfo  sp_spaceusage  sp_spaceused  sp_unbindexeclass 
object_cinfosp_add_qpgroup  sp_addobjectdef  sp_aux_get_qpgroup  sp_aux_sys_encr_passwd_lookup  sp_bindexeclass  sp_config_rep_agent  sp_dropobjectdef  sp_dropuser  sp_help  sp_help_qpgroup  sp_helpobjectdef  sp_rename  sp_rename_qpgroup  sp_showcontrolinfo  sp_unbindexeclass 
objectsp_add_qpgroup  sp_aux_get_qpgroup  sp_aux_sys_encr_passwd_lookup  sp_bindcache  sp_bindexeclass  sp_config_rep_agent  sp_drop_qpgroup  sp_droplockpromote  sp_droplockpromote_ptn  sp_dropuser  sp_encryption  sp_help  sp_help_qpgroup  sp_helpindex  sp_logiosize  sp_passwordpolicy  sp_rename  sp_rename_qpgroup  sp_replication_path  sp_setlockpromote  sp_setlockpromote_ptn  sp_showcontrolinfo  sp_spaceusage  sp_spaceused  sp_ssladmin  sp_unbindexeclass 
object_info1sp_addobjectdef  sp_bindcache  sp_bindexeclass  sp_config_rep_agent  sp_dropobjectdef  sp_dropuser  sp_encryption  sp_help  sp_helpindex  sp_helpobjectdef  sp_replication_path  sp_setlockpromote  sp_setlockpromote_ptn  sp_showcontrolinfo  sp_spaceusage  sp_spaceused  sp_unbindexeclass 
object_info2sp_addobjectdef  sp_aux_sys_encr_passwd_lookup  sp_encryption  sp_help  sp_helpobjectdef  sp_replication_path  sp_setlockpromote  sp_setlockpromote_ptn 
object_info3sp_addobjectdef  sp_rename  sp_setlockpromote  sp_setlockpromote_ptn  sp_showcontrolinfo  sp_unbindexeclass 
int_valuesp_bindcache  sp_config_rep_agent  sp_encryption  sp_help  sp_helpindex  sp_helpobjectdef  sp_logiosize  sp_passwordpolicy  sp_replication_path  sp_showcontrolinfo  sp_ssladmin 
char_valuesp_addobjectdef  sp_aux_encr_verify_downgrade  sp_bindcache  sp_bindexeclass  sp_config_rep_agent  sp_encryption  sp_help  sp_helpindex  sp_helpobjectdef  sp_repdbsync  sp_replication_path  sp_setlockpromote  sp_setlockpromote_ptn  sp_showcontrolinfo  sp_ssladmin  sp_unbindexeclass 
image_valuesp_encryption 
commentssp_help  sp_helpindex 

QUERIES
Joined With Links
master..spt_values sybsystemprocs..sp_helpobjectdef:188
sybsystemprocs..sp_helpobjectdef:214
sybsystemprocs..sp_helpobjectdef:51
sybsystemprocs..syscolumns sybsystemprocs..sp_help:680
master..sysattributes master..sysattributes sybsystemprocs..sysindexes sybsystemprocs..sp_spaceused:449
master..sysattributes master..sysattributes sybsystemprocs..sp_help:1070
sybsystemprocs..sp_spaceused:715
master..sysattributes master..sysattributes sybsystemprocs..sp_help:928
sybsystemprocs..sp_encryption:1495
sybsystemprocs..sp_encryption:3143
sybsystemprocs..sp_replication_path:1445

COLUMN WRITES detailed
ColumnWritten From
class  sp_config_rep_agent.@?   sp_bindexeclass.@?   sp_logiosize.@?   sp_addobjectdef.@?   sp_setlockpromote.@?   sp_setlockpromote_ptn.@?   sp_repdbsync.@?   sp_aux_sargs_qpgroup.@?   sp_unbindexeclass.@?   sp_bindcache.@?  
attribute  sp_config_rep_agent.@?   sp_bindexeclass.@?   sp_logiosize.@?   sp_addobjectdef.@?   sp_setlockpromote.@?   sp_setlockpromote_ptn.@?   sp_repdbsync.@?   sp_aux_sargs_qpgroup.@?   sp_unbindexeclass.@?   sp_bindcache.@?  
object_type  sp_bindexeclass.@object_type   sp_bindcache.@?   sp_unbindexeclass.@?   sp_bindexeclass.@?   sp_repdbsync.@?   sp_setlockpromote.@?   sp_unbindexeclass.@object_type   sp_logiosize.@?   sp_addobjectdef.@?   sp_aux_sargs_qpgroup.@?   sp_config_rep_agent.@?   sp_setlockpromote_ptn.@?   sp_aux_parse_entity.@?  
object_cinfo  sp_config_rep_agent.@?   sp_addobjectdef.@?   sp_rename_qpgroup.@new_name   sp_unbindexeclass.@object_name   sp_import_qpgroup.@group   sp_addtabledef.@tablename   sp_bindexeclass.@object_name   sp_namecrack.@?   sp_rename.@newname  
object    sysdatabases.dbid   sysattributes.object   sysobjects.id   sp_add_qpgroup.@?   sp_aux_parse_entity.@?   sp_unbindcache.@tablename   sp_unbindcache.@dbname   sp_config_rep_agent.@?   sp_logiosize.@?   sp_setlockpromote_ptn.@?   sp_setlockpromote.@?  
object_info1    sysattributes.object_info1   sysattributes.object_info1   °.object   spt_values.low   sysconfigures.value   sysindexes.indid   syscurconfigs.value   sysusers.uid   spt_values.number   sysattributes.int_value  
sysservers.srvid   syslogins.suid   sysdatabases.dbid   sp_setsuspect_granularity.@?   sp_clearpsexe.@spid   sp_multdb_bind.@?   sp_setsuspect_granularity.@dbname   sp_dbrecovery_order.@rec_order   sp_config_dump.@backup_srv_name   sp_helpsort.@?   sp_addexternlogin.@?   sp_config_dump.@notify   sp_config_dump.@retry   sp_cacheconfig.@parm1   sp_config_dump.@num_stripes   sp_config_dump.@retaindays   sp_optgoal.@?   sp_setpsexe.@spid   sp_aux_getsize.@?   sp_multdb_creategroup.@?   sp_shmdumpconfig.@maxdumps   sp_setlockpromote.@?   sp_config_dump.@ext_api   sp_displaylevel.@loginame   sp_memlog.@?   sp_unbindexeclass.@?   sp_setpglockpromote.@new_lwm   sp_config_dump.@init   sp_namecrack.@?   sp_hadr_admin.@?   sp_maplogin.@?   sp_setsuspect_threshold.@?   sp_dbrecovery_order.@?   sp_config_dump.@stripe_dir   sp_makesuspect_obj.@?   sp_setrowlockpromote.@new_lwm   sp_shmdumpconfig.@?   sp_hadr_update.@genno   sp_addlogin.@maxfailedlogins   sp_config_dump.@compression   sp_makesuspect_obj.@objname   sp_addtabledef.@tablename   sp_memlog.@dumps_per_file   sp_config_dump.@?   sp_setpglockpromote_ptn.@new_lwm   sp_dboption_flmode.@?   sp_optbitmap.@?   sp_config_dump.@blocksize   sp_cacheconfig.@?   sp_rjs_register.@host_port   sp_modifylogin.@?   sp_addexternlogin.@loginame   sp_config_dump.@verify   sp_adduser.@?   sp_addlogin.@passwdexp   sp_addobjectdef.@?   sp_config_rep_agent.@?   sp_bindexeclass.@?   sp_dbrecovery_order.@dbname   sp_addserver.@?   sp_gen_login_id.@?   sp_downgrade_dump_config.@?   sp_do_poolconfig.@?   sp_shmdumpconfig_config.@?   sp_setsuspect_error.@errornum   sp_setrowlockpromote_ptn.@new_lwm   sp_addlogin.@minpwdlen   sp_aux_parse_entity.@?   sp_displaylevel.@?   sp_dboption_flmode.@?   sp_aux_getsize.@input_size   sp_addgroup.@?   sp_poolconfig.@parm1   sp_do_poolconfig.@parm1   sp_setlockpromote.@new_lwm   sp_setlockpromote_ptn.@?   sp_shmdumpconfig.@value   sp_fix_dtm_ha_roles.@?   sp_modifylogin.@value   sp_makesuspect_obj.@dbname   sp_setsuspect_threshold.@dbname   sp_version.@?  
object_info2    syssrvroles.srid   sysattributes.object_info2   sysattributes.object_info2   spt_values.number   syscurconfigs.value   sysconfigures.value   sp_aux_getsize.@?   sp_maplogin.@?   sp_cacheconfig.@parm1   sp_setsuspect_granularity.@?   sp_setrowlockpromote.@new_hwm   sp_setrowlockpromote_ptn.@new_hwm   sp_poolconfig.@parm1   sp_setsuspect_threshold.@threshold   sp_addexternlogin.@?   sp_setlockpromote_ptn.@?   sp_makesuspect_obj.@?   sp_setlockpromote.@?   sp_do_poolconfig.@?   sp_aux_getsize.@input_size   sp_cacheconfig.@?   sp_setpglockpromote.@new_hwm   sp_fix_dtm_ha_roles.@?   sp_helpsort.@?   sp_setpglockpromote_ptn.@new_hwm   sp_do_poolconfig.@parm1   sp_setlockpromote.@new_hwm  
object_info3    sysattributes.object   syslogins.suid   sysattributes.int_value   sysservers.srvid   spt_values.number   sysdatabases.dbid   sysattributes.object_info3   sysattributes.object_info3   sp_displaylevel.@loginame   sp_addengine.@?   sp_shmdumpconfig.@maxdumps   sp_memlog.@?   sp_dbrecovery_order.@dbname   sp_setsuspect_error.@errornum   sp_config_dump.@?   sp_rjs_register.@host_port   sp_setsuspect_threshold.@?   sp_maplogin.@?   sp_downgrade_dump_config.@?   sp_config_dump.@backup_srv_name   sp_multdb_bind.@?   sp_config_dump.@ext_api   sp_setpglockpromote.@new_pct   sp_version.@?   sp_setlockpromote_ptn.@?   sp_config_dump.@retry   sp_setrowlockpromote_ptn.@new_pct   sp_config_dump.@verify   sp_addengine.@instanceid   sp_gen_login_id.@?   sp_shmdumpconfig.@?   sp_config_dump.@blocksize   sp_config_dump.@init   sp_hadr_admin.@?   sp_unbindexeclass.@?   sp_setsuspect_granularity.@dbname   sp_modifylogin.@value   sp_optbitmap.@?   sp_config_dump.@num_stripes   sp_shmdumpconfig_config.@?   sp_multdb_creategroup.@?   sp_setsuspect_threshold.@dbname   sp_fix_dtm_ha_roles.@?   sp_bindexeclass.@?   sp_setlockpromote.@new_pct   sp_shmdumpconfig.@value   sp_addserver.@?   sp_addlogin.@minpwdlen   sp_modifylogin.@?   sp_setrowlockpromote.@new_pct   sp_addexeclass.@?   sp_setpglockpromote_ptn.@new_pct   sp_config_dump.@compression   sp_addexternlogin.@loginame   sp_dropengine.@instanceid   sp_config_dump.@stripe_dir   sp_displaylevel.@?   sp_setsuspect_granularity.@?   sp_config_dump.@notify   sp_dbrecovery_order.@rec_order   sp_addlogin.@maxfailedlogins   sp_addexeclass.@instanceid   sp_optgoal.@?   sp_dbrecovery_order.@?   sp_dropengine.@?   sp_helpsort.@?   sp_addexternlogin.@?   sp_addobjectdef.@?   sp_addlogin.@passwdexp   sp_config_dump.@retaindays   sp_hadr_update.@genno  
int_value    syslogins.suid   syssrvroles.srid   sysattributes.object_info1   sysattributes.object_info1   sysdatabases.dbid   spt_values.low   sysattributes.object_info3   sysattributes.char_value   °.object_info2   sysattributes.object_info2  
sysconfigures.value   sysindexes.indid   sysattributes.char_value   °.int_value   sysusers.uid   sysattributes.object_info3   spt_values.number   sysattributes.object   sysservers.srvid   syscurconfigs.value  
sysattributes.int_value   sp_makesuspect_obj.@indid   sp_optbitmap.@bitmap   sp_setlockpromote.@new_hwm   sp_dropengine.@instanceid   sp_aux_getsize.@?   sp_poolconfig.@parm1   sp_shmdumpconfig_config.@?   sp_setpsexe.@value   sp_makesuspect_obj.@errorcnt   sp_rjs_register.@host_name   sp_gen_login_id.@?   sp_setpglockpromote_ptn.@new_lwm   sp_tempdb.@arg4   sp_config_dump.@init   sp_addtabledef.@objectdef   sp_config_dump.@verify   sp_setpsexe.@?   sp_makesuspect_obj.@errtype   sp_modifylogin.@value   sp_config_dump.@compression   sp_config_rep_agent.@configvalue   sp_modifylogin.@?   sp_addexternlogin.@loginame   sp_config_dump.@stripe_dir   sp_addserver.@?   sp_addengine.@?   sp_multdb_creategroup.@?   sp_setsuspect_error.@errornum   sp_addserver.@lname   sp_addserver.@pname   sp_logintrigger.@trigname   sp_do_poolconfig.@parm1   sp_makesuspect_obj.@pgtype   sp_config_dump.@num_stripes   sp_config_dump.@?   sp_do_poolconfig.@?   sp_cacheconfig.@?   sp_addengine.@engine_number   sp_shmdumpconfig.@value   sp_setlockpromote.@?   sp_config_dump.@backup_srv_name   sp_config_rep_agent.@?   sp_config_dump.@retaindays   sp_setlockpromote.@new_lwm   sp_setrowlockpromote.@new_hwm   sp_memlog.@dumps_per_file   sp_logiosize.@size   sp_addobjectdef.@?   sp_hadr_admin.@?   sp_addgroup.@?   sp_shmdumpconfig.@?   sp_setpglockpromote.@new_hwm   sp_config_dump.@notify   sp_addtabledef.@tablename   sp_addengine.@instanceid   sp_addexternlogin.@?   sp_dropengine.@?   sp_repdbsync.@label   sp_addlogin.@passwdexp   sp_memlog.@?   sp_setrowlockpromote_ptn.@new_hwm   sp_bindexeclass.@classname   sp_config_rep_agent.@rs_password   sp_dboption_flmode.@?   sp_setsuspect_granularity.@?   sp_setrowlockpromote.@new_pct   sp_setsuspect_granularity.@dbname   sp_config_rep_agent.@rs_encpwd   sp_setlockpromote.@new_pct   sp_makesuspect_obj.@errdelay   sp_multdb_bind.@?   sp_setpglockpromote.@new_pct   sp_addlogin.@minpwdlen   sp_setsuspect_threshold.@dbname   sp_fix_dtm_ha_roles.@?   sp_forceonline_page.@?   sp_optbitmap.@?   sp_displaylevel.@loginame   sp_setsuspect_threshold.@threshold   sp_displaylevel.@?   sp_setrowlockpromote_ptn.@new_pct   sp_dboption_flmode.@?   sp_version.@?   sp_dbrecovery_order.@dbname   sp_addexeclass.@instanceid   sp_setrowlockpromote.@new_lwm   sp_version.@version   sp_addexeclass.@timeslice   sp_rjs_register.@host_port   sp_setlockpromote_ptn.@?   sp_makesuspect_obj.@logtype   sp_bindexeclass.@?   sp_namecrack.@?   sp_forceonline_object.@?   sp_setsuspect_threshold.@?   sp_optgoal.@?   sp_shmdumpconfig.@maxdumps   sp_aux_parse_entity.@?   sp_unbindcache.@?   sp_dbrecovery_order.@?   sp_unbindexeclass.@?   sp_maplogin.@?   sp_setrowlockpromote_ptn.@new_lwm   sp_setpglockpromote_ptn.@new_hwm   sp_makesuspect_obj.@objname   sp_shmdumpconfig.@dirname   sp_downgrade_dump_config.@?   sp_config_dump.@retry   sp_hadr_update.@genno   sp_setpglockpromote.@new_lwm   sp_logiosize.@?   sp_shmdumpconfig.@filename   sp_makesuspect_obj.@dbname   sp_makesuspect_obj.@?   sp_setpsexe.@spid   sp_bindcache.@?   sp_clearpsexe.@spid   sp_config_dump.@blocksize   sp_helpsort.@?   sp_config_dump.@ext_api   sp_addlogin.@maxfailedlogins   sp_cacheconfig.@parm1   sp_addexeclass.@priority   sp_setsuspect_granularity.@option   sp_addexeclass.@group   sp_aux_getsize.@input_size   sp_addexeclass.@?   sp_setpglockpromote_ptn.@new_pct   sp_dbrecovery_order.@rec_order   sp_adduser.@?  
char_value    syslogins.suid   syssrvroles.srid   sysattributes.object_info1   sysattributes.object_info1   sysdatabases.dbid   spt_values.low   sysattributes.object_info3   sysattributes.char_value   °.object_info2   sysattributes.object_info2  
sysconfigures.value   sysindexes.indid   sysattributes.char_value   °.int_value   sysusers.uid   sysattributes.object_info3   spt_values.number   sysattributes.object   sysservers.srvid   syscurconfigs.value  
sysattributes.int_value   sp_setsuspect_error.@errornum   sp_multdb_creategroup.@?   sp_clearpsexe.@spid   sp_multdb_bind.@?   sp_setsuspect_granularity.@dbname   sp_config_rep_agent.@rs_encpwd   sp_config_dump.@backup_srv_name   sp_cacheconfig.@?   sp_unbindcache.@?   sp_helpsort.@?   sp_addexternlogin.@?   sp_optbitmap.@bitmap   sp_poolconfig.@parm1   sp_config_dump.@retry   sp_bindcache.@?   sp_version.@?   sp_setrowlockpromote_ptn.@new_pct   sp_downgrade_dump_config.@?   sp_cacheconfig.@parm1   sp_forceonline_page.@?   sp_config_dump.@num_stripes   sp_config_dump.@retaindays   sp_optgoal.@?   sp_addengine.@?   sp_displaylevel.@?   sp_dbrecovery_order.@rec_order   sp_makesuspect_obj.@errorcnt   sp_setpsexe.@spid   sp_aux_getsize.@?   sp_setlockpromote.@new_pct   sp_logiosize.@?   sp_addengine.@instanceid   sp_addtabledef.@objectdef   sp_setlockpromote.@?   sp_setrowlockpromote.@new_hwm   sp_addserver.@pname   sp_setpglockpromote.@new_hwm   sp_config_dump.@ext_api   sp_displaylevel.@loginame   sp_memlog.@?   sp_unbindexeclass.@?   sp_config_dump.@init   sp_namecrack.@?   sp_addserver.@lname   sp_hadr_admin.@?   sp_maplogin.@?   sp_shmdumpconfig.@?   sp_logintrigger.@trigname   sp_setpsexe.@value   sp_dropengine.@instanceid   sp_bindexeclass.@classname   sp_dboption_flmode.@?   sp_setpglockpromote_ptn.@new_hwm   sp_config_dump.@stripe_dir   sp_addexeclass.@instanceid   sp_setrowlockpromote.@new_lwm   sp_setpglockpromote.@new_lwm   sp_rjs_register.@host_port   sp_hadr_update.@genno   sp_config_dump.@notify   sp_setsuspect_threshold.@threshold   sp_config_dump.@compression   sp_makesuspect_obj.@objname   sp_addtabledef.@tablename   sp_setsuspect_granularity.@option   sp_memlog.@dumps_per_file   sp_config_dump.@?   sp_logiosize.@size   sp_setpglockpromote_ptn.@new_lwm   sp_setsuspect_granularity.@?   sp_addexeclass.@priority   sp_optbitmap.@?   sp_config_dump.@blocksize   sp_do_poolconfig.@parm1   sp_repdbsync.@label   sp_version.@version   sp_makesuspect_obj.@?   sp_modifylogin.@?   sp_setsuspect_threshold.@?   sp_config_rep_agent.@configvalue   sp_addexternlogin.@loginame   sp_tempdb.@arg4   sp_config_dump.@verify   sp_adduser.@?   sp_forceonline_object.@?   sp_addengine.@engine_number   sp_shmdumpconfig.@filename   sp_addexeclass.@group   sp_addobjectdef.@?   sp_makesuspect_obj.@errdelay   sp_config_rep_agent.@?   sp_setrowlockpromote_ptn.@new_hwm   sp_addlogin.@maxfailedlogins   sp_dbrecovery_order.@dbname   sp_makesuspect_obj.@indid   sp_dbrecovery_order.@?   sp_addserver.@?   sp_setrowlockpromote.@new_pct   sp_setpglockpromote.@new_pct   sp_do_poolconfig.@?   sp_gen_login_id.@?   sp_dboption_flmode.@?   sp_setlockpromote.@new_hwm   sp_shmdumpconfig_config.@?   sp_bindexeclass.@?   sp_setrowlockpromote_ptn.@new_lwm   sp_addlogin.@minpwdlen   sp_aux_parse_entity.@?   sp_shmdumpconfig.@value   sp_setpglockpromote_ptn.@new_pct   sp_shmdumpconfig.@dirname   sp_shmdumpconfig.@maxdumps   sp_addgroup.@?   sp_rjs_register.@host_name   sp_addexeclass.@timeslice   sp_config_rep_agent.@rs_password   sp_makesuspect_obj.@logtype   sp_setlockpromote.@new_lwm   sp_setlockpromote_ptn.@?   sp_fix_dtm_ha_roles.@?   sp_addexeclass.@?   sp_dropengine.@?   sp_modifylogin.@value   sp_addlogin.@passwdexp   sp_makesuspect_obj.@errtype   sp_makesuspect_obj.@dbname   sp_setsuspect_threshold.@dbname   sp_setpsexe.@?   sp_aux_getsize.@input_size   sp_makesuspect_obj.@pgtype  

DATA PROPAGATION detailed
ColumnWritten To
char_valuesysattributes.int_value   °.char_value   sp_passwordpolicy_rset_002.value sp_passwordpolicy_rset_003.value sp_passwordpolicy_rset_004.Policy_option sp_ssladmin_rset_001.certificate_path sp_ssladmin_rset_002.Cipher Suite Name °.Preference
int_valuesysattributes.int_value   °.char_value   sp_passwordpolicy_rset_002.value sp_passwordpolicy_rset_003.value sp_passwordpolicy_rset_004.Policy_option sp_ssladmin_rset_001.certificate_path sp_ssladmin_rset_002.Cipher Suite Name °.Preference
objectsysattributes.object   sysqueryplans.gid   sp_find_qplan_rset_001.gid sp_help_qplan_rset_001.hashkey sp_help_qplan_rset_004.query_plan sp_passwordpolicy_rset_002.message sp_show_metrics_rset_001.Group ID sp_show_query_tuning_rset_001.Group ID
object_info1sysattributes.object_info1   °.char_value   sysattributes.object_info1   °.int_value   °.char_value   sp_dropdevice_rset_001.device sp_displayroles_rset_001.Role Name sp_displayroles_rset_002.Role Name sp_displayroles_rset_003.Role Name sp_displayroles_rset_004.Role Name
sp_dropdevice_rset_001.device sp_forceonline_object_rset_001.Object °.status sp_forceonline_object_rset_002.Object °.status sp_forceonline_page_rset_001.status sp_forceonline_page_rset_002.status sp_listsuspect_object_rset_001.Object °.Access sp_listsuspect_page_rset_001.Object
°.Access sp_makesuspect_obj_rset_001.Obj °.Indid °.LogType °.PageType °.ErrType °.Delay °.TotalNum sp_makesuspect_obj_rset_002.Obj °.Indid
°.LogType °.PageType °.ErrType °.Delay °.TotalNum sp_makesuspect_obj_rset_003.Obj °.Indid °.LogType °.PageType °.ErrType
°.Delay °.TotalNum sp_memlog_rset_001.dumps_per_file sp_passwordpolicy_rset_001.message sp_passwordpolicy_rset_002.value sp_passwordpolicy_rset_003.value sp_passwordpolicy_rset_004.Policy_option sp_rjs_retrieve_rset_001.host_name sp_setsuspect_granularity_rset_001.Online mode sp_ssladmin_rset_001.certificate_path
sp_ssladmin_rset_002.Cipher Suite Name °.Preference
object_info2sysattributes.object_info2   °.char_value   sysattributes.object_info2   °.int_value   °.char_value   sp_dropdevice_rset_001.device sp_dropdevice_rset_001.device sp_forceonline_object_rset_001.Index °.status sp_forceonline_object_rset_002.Index
°.status sp_forceonline_page_rset_001.status sp_forceonline_page_rset_002.status sp_listsuspect_object_rset_001.Index °.Access sp_listsuspect_page_rset_001.Index °.Access sp_makesuspect_obj_rset_001.Indid °.LogType °.PageType
°.ErrType °.Delay °.TotalNum sp_makesuspect_obj_rset_002.Indid °.LogType °.PageType °.ErrType °.Delay °.TotalNum sp_makesuspect_obj_rset_003.Indid
°.LogType °.PageType °.ErrType °.Delay °.TotalNum sp_passwordpolicy_rset_001.message sp_passwordpolicy_rset_002.value sp_passwordpolicy_rset_003.value sp_passwordpolicy_rset_004.Policy_option sp_rjs_retrieve_rset_001.host_name
sp_setsuspect_granularity_rset_001.Online mode sp_setsuspect_threshold_rset_001.Cfg. Suspect threshold sp_setsuspect_threshold_rset_002.Cfg. Suspect Threshold sp_ssladmin_rset_001.certificate_path sp_ssladmin_rset_002.Cipher Suite Name °.Preference
object_info3sysattributes.object_info3   °.char_value   sysattributes.object_info3   °.int_value   °.char_value   sp_dropdevice_rset_001.device sp_dropdevice_rset_001.device sp_forceonline_object_rset_001.status sp_forceonline_object_rset_002.status sp_forceonline_page_rset_001.status
sp_forceonline_page_rset_002.status sp_listsuspect_object_rset_001.Access sp_listsuspect_page_rset_001.Access sp_makesuspect_obj_rset_001.Indid °.LogType °.PageType °.ErrType °.Delay °.TotalNum sp_makesuspect_obj_rset_002.Indid
°.LogType °.PageType °.ErrType °.Delay °.TotalNum sp_makesuspect_obj_rset_003.Indid °.LogType °.PageType °.ErrType °.Delay
°.TotalNum sp_passwordpolicy_rset_001.message sp_passwordpolicy_rset_002.value sp_passwordpolicy_rset_003.value sp_passwordpolicy_rset_004.Policy_option sp_rjs_retrieve_rset_001.host_name sp_setsuspect_granularity_rset_001.Online mode sp_ssladmin_rset_001.certificate_path sp_ssladmin_rset_002.Cipher Suite Name °.Preference

DEPENDENCIES
READERS AND WRITERS
read_written by proc sybsystemprocs..sp_bindexeclass  
read by proc sybsystemprocs..sp_aux_encr_verify_downgrade  
read by proc sybsystemprocs..sp_ssladmin  
read by proc sybsystemprocs..sp_spaceusage  
read_written by proc sybsystemprocs..sp_setlockpromote  
   called by proc sybsystemprocs..sp_setrowlockpromote  
   called by proc sybsystemprocs..sp_setpglockpromote  
read by proc sybsystemprocs..sp_help  
read by proc sybsystemprocs..sp_spaceused  
read_written by proc sybsystemprocs..sp_repdbsync  
written by proc sybsystemprocs..sp_rename_qpgroup  
read by proc sybsystemprocs..sp_helpindex  
   called by proc sybsystemprocs..sp_help  
read_written by proc sybsystemprocs..sp_logiosize  
read by proc sybsystemprocs..sp_replication_path  
read_written by proc sybsystemprocs..sp_droplockpromote  
   called by proc sybsystemprocs..sp_droprowlockpromote  
   called by proc sybsystemprocs..sp_dropglockpromote  
read by proc sybsystemprocs..sp_aux_sys_encr_passwd_lookup  
read_written by proc sybsystemprocs..sp_droplockpromote_ptn  
   called by proc sybsystemprocs..sp_droprowlockpromote_ptn  
   called by proc sybsystemprocs..sp_dropglockpromote_ptn  
read_written by proc sybsystemprocs..sp_setlockpromote_ptn  
   called by proc sybsystemprocs..sp_setpglockpromote_ptn  
   called by proc sybsystemprocs..sp_setrowlockpromote_ptn  
read by proc sybsystemprocs..sp_passwordpolicy  
   called by proc sybsystemprocs..sp_downgrade  
read_written by proc sybsystemprocs..sp_dropobjectdef  
   called by proc sybsystemprocs..sp_droptabledef  
read by proc sybsystemprocs..sp_helpobjectdef  
read_written by proc sybsystemprocs..sp_rename  
read_written by proc sybsystemprocs..sp_addobjectdef  
   called by proc sybsystemprocs..sp_addtabledef  
read by proc sybsystemprocs..sp_help_qpgroup  
read by proc sybsystemprocs..sp_showcontrolinfo  
read_written by proc sybsystemprocs..sp_bindcache  
   called by proc sybsystemprocs..sp_unbindcache  
read_written by proc sybsystemprocs..sp_config_rep_agent  
read_written by proc sybsystemprocs..sp_dropuser  
read_written by proc sybsystemprocs..sp_unbindexeclass  
read by proc sybsystemprocs..sp_aux_get_qpgroup  
   called by proc sybsystemprocs..sp_rename_qpgroup  
   called by proc sybsystemprocs..sp_drop_qpgroup  
   called by proc sybsystemprocs..sp_copy_all_qplans  
   called by proc sybsystemprocs..sp_export_qpgroup  
   called by proc sybsystemprocs..sp_add_qpgroup  
      called by proc sybsystemprocs..sp_import_qpgroup  
   called by proc sybsystemprocs..sp_copy_qplan  
      called by proc sybsystemprocs..sp_copy_all_qplans  
   called by proc sybsystemprocs..sp_import_qpgroup  
   called by proc sybsystemprocs..sp_drop_all_qplans  
   called by proc sybsystemprocs..sp_help_qpgroup  
   called by proc sybsystemprocs..sp_cmp_all_qplans  
   called by proc sybsystemprocs..sp_find_qplan  
read_written by proc sybsystemprocs..sp_add_qpgroup  
read by proc sybsystemprocs..sp_encryption  
   called by proc sybsystemprocs..sp_downgrade  
written by proc sybsystemprocs..sp_drop_qpgroup