DatabaseTableApplicationCreatedLinks
mastersysattributes  31 Aug 14Joins Schema ColumnUsage Queries Dependencies

1     create table sysattributes(-- 712 Rows, Data: 46 KB, Index: 88 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    create unique clustered index csysattributes on sysattributes(-- 22 KB refcount: 335
20        class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo
21    )
22    create index ncsysattributes on sysattributes(-- 20 KB refcount: 0
23        object_type, object, object_info1, object_info2, object_info3, object_cinfo, object_cinfo2, object_datetime
24    )
25    
26    alter table sysattributes lock datarows
27    
28    Grant Select on sysattributes to public
29    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[object]master..syslogins[suid]10 FK
[object_info1]master..sysservers[srvid]10 FK
[object, object_info1]sybsystemprocs..sysattributes[class, attribute]8 Simple Join
[object]sybsystemprocs..sysattributes[class]8 Simple Join
[object_info1]master..spt_values[low]6 Simple Join
[object]master..sysdatabases[dbid]4 FK
[object_cinfo]master..spt_values[name]4 Simple Join
[object]master..sysdatabases[name]2 FK
[object_info2]master..syssrvroles[srid]2 FK
[class, attribute]master..sysattributes[object, object_info1]2 Simple Join
[class]master..sysattributes[object]2 Simple Join
[int_value]master..sysattributes[object]2 Simple Join
[object, object_info1]master..sysattributes[class, attribute]2 Simple Join
[object]master..sysattributes[class]2 Simple Join
[object]master..sysattributes[int_value]2 Simple Join
[object]master..syscurconfigs[config]2 Simple Join

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

ALIASES USED for master..sysattributes
NO_ALIASaanattbccnsasysattributest1t2
187172164247711

SCHEMA

COLUMN USAGE
classsp_activeroles  sp_addengine  sp_addexeclass  sp_addexternlogin  sp_addlogin  sp_addserver  sp_aux_securityprofile_getattr  sp_bindexeclass  sp_clearpsexe  sp_configure  sp_dboption  sp_dboption_flmode  sp_dbrecovery_order  sp_displaylevel  sp_displaylogin  sp_displayroles  sp_dropdevice  sp_dropengine  sp_dropexeclass  sp_dropexternlogin  sp_droplogin  sp_dropserver  sp_encryption  sp_fix_dtm_ha_roles  sp_forceonline_db  sp_forceonline_object  sp_forceonline_page  sp_help  sp_helpdb  sp_helpexternlogin  sp_helpindex  sp_helpmaplogin  sp_helprotect  sp_ldapadmin  sp_listsuspect_db  sp_listsuspect_object  sp_listsuspect_page  sp_locklogin  sp_logintrigger  sp_makesuspect_obj  sp_maplogin  sp_memlog  sp_modifylogin  sp_multdb_addtogroup  sp_multdb_bind  sp_multdb_creategroup  sp_multdb_dropgroup  sp_multdb_removefromgroup  sp_multdb_show  sp_multdb_unbind  sp_multdb_unbindall_db  sp_multdb_unbindall_gr  sp_plan_dbccdb  sp_rjs_register  sp_rjs_retrieve  sp_rjs_unregister  sp_securityprofile  sp_setpsexe  sp_setsuspect_error  sp_setsuspect_granularity  sp_setsuspect_threshold  sp_shmdumpconfig  sp_shmdumpconfig_config  sp_shmdumpdisp  sp_shmdumpdrop  sp_shmdumpsize  sp_showexeclass  sp_spaceused  sp_ssladmin  sp_unbindcache_all  sp_unbindexeclass  sp_version  udf_inactivity_check 
attributesp_activeroles  sp_addengine  sp_addexeclass  sp_addexternlogin  sp_addlogin  sp_addserver  sp_aux_securityprofile_getattr  sp_bindexeclass  sp_clearpsexe  sp_configure  sp_dboption_flmode  sp_dbrecovery_order  sp_displaylevel  sp_displaylogin  sp_displayroles  sp_dropdevice  sp_dropengine  sp_dropexeclass  sp_dropexternlogin  sp_dropserver  sp_encryption  sp_fix_dtm_ha_roles  sp_forceonline_db  sp_forceonline_object  sp_forceonline_page  sp_help  sp_helpdb  sp_helpindex  sp_helpmaplogin  sp_helprotect  sp_ldapadmin  sp_listsuspect_db  sp_listsuspect_object  sp_listsuspect_page  sp_locklogin  sp_logintrigger  sp_makesuspect_obj  sp_maplogin  sp_memlog  sp_modifylogin  sp_multdb_addtogroup  sp_multdb_bind  sp_multdb_creategroup  sp_multdb_dropgroup  sp_multdb_removefromgroup  sp_multdb_show  sp_multdb_unbind  sp_multdb_unbindall_db  sp_multdb_unbindall_gr  sp_plan_dbccdb  sp_rjs_register  sp_rjs_unregister  sp_securityprofile  sp_setpsexe  sp_setsuspect_error  sp_setsuspect_granularity  sp_setsuspect_threshold  sp_shmdumpconfig  sp_shmdumpconfig_config  sp_shmdumpdisp  sp_shmdumpdrop  sp_shmdumpsize  sp_showexeclass  sp_spaceused  sp_unbindcache_all  sp_unbindexeclass  sp_version  udf_inactivity_check 
object_typesp_activeroles  sp_addengine  sp_addexeclass  sp_addexternlogin  sp_addlogin  sp_addserver  sp_bindexeclass  sp_clearpsexe  sp_configure  sp_dboption_flmode  sp_dbrecovery_order  sp_displaylevel  sp_displaylogin  sp_displayroles  sp_dropdevice  sp_dropengine  sp_dropexeclass  sp_droplogin  sp_dropserver  sp_fix_dtm_ha_roles  sp_forceonline_db  sp_forceonline_object  sp_forceonline_page  sp_helpdb  sp_helpexternlogin  sp_helprotect  sp_listsuspect_db  sp_listsuspect_object  sp_listsuspect_page  sp_logintrigger  sp_makesuspect_obj  sp_maplogin  sp_memlog  sp_modifylogin  sp_multdb_addtogroup  sp_multdb_bind  sp_multdb_creategroup  sp_multdb_dropgroup  sp_multdb_removefromgroup  sp_multdb_show  sp_multdb_unbind  sp_multdb_unbindall_gr  sp_plan_dbccdb  sp_rjs_register  sp_rjs_unregister  sp_securityprofile  sp_setpsexe  sp_setsuspect_error  sp_setsuspect_granularity  sp_setsuspect_threshold  sp_shmdumpconfig  sp_shmdumpconfig_config  sp_shmdumpdisp  sp_shmdumpdrop  sp_shmdumpsize  sp_showexeclass  sp_spaceused  sp_unbindcache_all  sp_unbindexeclass  sp_version  udf_inactivity_check 
object_cinfosp_addengine  sp_addexeclass  sp_addexternlogin  sp_addlogin  sp_addserver  sp_bindexeclass  sp_clearpsexe  sp_displaylogin  sp_displayroles  sp_dropdevice  sp_dropengine  sp_dropexeclass  sp_droplogin  sp_dropserver  sp_fix_dtm_ha_roles  sp_helpexternlogin  sp_helpmaplogin  sp_maplogin  sp_modifylogin  sp_multdb_addtogroup  sp_multdb_bind  sp_multdb_creategroup  sp_multdb_dropgroup  sp_multdb_removefromgroup  sp_multdb_show  sp_multdb_unbind  sp_multdb_unbindall_gr  sp_passwordpolicy  sp_rjs_register  sp_rjs_retrieve  sp_rjs_unregister  sp_setpsexe  sp_showexeclass  sp_unbindexeclass  sp_version  udf_inactivity_check 
objectsp_activeroles  sp_addexeclass  sp_addexternlogin  sp_addlogin  sp_addserver  sp_aux_securityprofile_getattr  sp_bindexeclass  sp_configure  sp_dboption  sp_dboption_flmode  sp_dbrecovery_order  sp_displaylevel  sp_displaylogin  sp_displayroles  sp_dropdevice  sp_dropexternlogin  sp_droplogin  sp_fix_dtm_ha_roles  sp_forceonline_db  sp_forceonline_object  sp_forceonline_page  sp_help  sp_helpdb  sp_helpexternlogin  sp_helpindex  sp_helpmaplogin  sp_helprotect  sp_listsuspect_db  sp_listsuspect_object  sp_listsuspect_page  sp_makesuspect_obj  sp_maplogin  sp_modifylogin  sp_multdb_addtogroup  sp_multdb_bind  sp_multdb_dropgroup  sp_multdb_removefromgroup  sp_multdb_show  sp_multdb_unbind  sp_plan_dbccdb  sp_securityprofile  sp_setsuspect_error  sp_setsuspect_granularity  sp_setsuspect_threshold  sp_shmdumpconfig  sp_shmdumpconfig_config  sp_shmdumpdisp  sp_shmdumpdrop  sp_spaceused  sp_unbindcache_all  sp_unbindexeclass  udf_inactivity_check 
object_info1sp_activeroles  sp_addexeclass  sp_addexternlogin  sp_bindexeclass  sp_clearpsexe  sp_dboption_flmode  sp_displayroles  sp_dropengine  sp_dropexternlogin  sp_droplogin  sp_dropserver  sp_forceonline_db  sp_forceonline_object  sp_help  sp_helpdb  sp_helpexternlogin  sp_helpindex  sp_helpmaplogin  sp_helprotect  sp_listsuspect_object  sp_listsuspect_page  sp_makesuspect_obj  sp_maplogin  sp_memlog  sp_modifylogin  sp_multdb_bind  sp_multdb_show  sp_setpsexe  sp_setsuspect_error  sp_shmdumpconfig  sp_shmdumpdisp  sp_shmdumpsize  sp_spaceused  sp_unbindexeclass 
object_info2sp_addexternlogin  sp_dropexternlogin  sp_forceonline_object  sp_helpexternlogin  sp_listsuspect_object  sp_listsuspect_page  sp_makesuspect_obj  sp_maplogin  sp_multdb_show  sp_setsuspect_granularity  sp_setsuspect_threshold 
object_info3sp_addengine  sp_addexeclass  sp_addexternlogin  sp_bindexeclass  sp_dropengine  sp_forceonline_db  sp_showexeclass  sp_unbindexeclass 
int_valuesp_addlogin  sp_addserver  sp_aux_securityprofile_getattr  sp_configure  sp_dbrecovery_order  sp_displaylevel  sp_displaylogin  sp_displayroles  sp_fix_dtm_ha_roles  sp_forceonline_object  sp_forceonline_page  sp_helpdb  sp_ldapadmin  sp_listsuspect_object  sp_listsuspect_page  sp_locklogin  sp_memlog  sp_modifylogin  sp_multdb_addtogroup  sp_multdb_bind  sp_multdb_creategroup  sp_multdb_dropgroup  sp_multdb_removefromgroup  sp_multdb_show  sp_multdb_unbindall_db  sp_multdb_unbindall_gr  sp_passwordpolicy  sp_rjs_register  sp_rjs_retrieve  sp_rjs_unregister  sp_setsuspect_error  sp_setsuspect_granularity  sp_setsuspect_threshold  sp_shmdumpconfig  sp_shmdumpconfig_config  sp_shmdumpdisp  sp_shmdumpsize  sp_version  udf_inactivity_check 
char_valuesp_addengine  sp_addexeclass  sp_addserver  sp_aux_securityprofile_getattr  sp_bindexeclass  sp_clearpsexe  sp_dboption  sp_dboption_flmode  sp_dropdevice  sp_dropengine  sp_forceonline_object  sp_forceonline_page  sp_help  sp_helpdb  sp_helpindex  sp_listsuspect_object  sp_listsuspect_page  sp_logintrigger  sp_makesuspect_obj  sp_multdb_bind  sp_multdb_dropgroup  sp_multdb_show  sp_multdb_unbindall_db  sp_multdb_unbindall_gr  sp_passwordpolicy  sp_plan_dbccdb  sp_rjs_register  sp_rjs_retrieve  sp_rjs_unregister  sp_setpsexe  sp_setsuspect_granularity  sp_shmdumpconfig  sp_shmdumpdisp  sp_showexeclass  sp_spaceused  sp_unbindcache_all  sp_unbindexeclass  sp_version 
image_valuesp_addexternlogin  sp_maplogin 
commentssp_dbrecovery_order  sp_helpdb  sp_ldapadmin  sp_ssladmin  sp_version 
object_cinfo2sp_addexternlogin 
object_datetimesp_addexternlogin 

QUERIES
Joined With Links
master..spt_values sybsystemprocs..sp_maplogin:444
sybsystemprocs..sp_maplogin:413
sybsystemprocs..sp_helpmaplogin:51
master..sysmessages master..spt_values sybsystemprocs..sp_passwordpolicy:296
sybsystemprocs..sp_passwordpolicy:310
sybsystemprocs..sp_multdb_show:156
master..syscurconfigs sybsystemprocs..sp_configure:1803
master..sysservers sybsystemprocs..sp_dropserver:271
sybsystemprocs..sp_dropserver:315
sybsystemprocs..sp_helpexternlogin:131
sybsystemprocs..sysattributes sybsystemprocs..sysindexes sybsystemprocs..sp_spaceused:267
master..syslogins master..sysservers sybsystemprocs..sp_helpexternlogin:117
master..syslogins sybsystemprocs..sp_multdb_show:192
sybsystemprocs..sp_multdb_show:261
sybsystemprocs..sp_multdb_show:177
sybsystemprocs..sp_multdb_show:244
master..sysservers master..syssrvroles sybsystemprocs..sp_helpexternlogin:160
master..sysdatabases sybsystemprocs..sp_dropdevice:132
sybsystemprocs..sp_dbrecovery_order:209
sybsystemprocs..sysattributes sybsystemprocs..sp_help:710
sybsystemprocs..sysattributes sybsystemprocs..sp_spaceused:535
sybsystemprocs..sp_help:852

DEPENDENCIES
READERS AND WRITERS
read_written by proc sybsystemprocs..sp_multdb_creategroup  
   called by proc sybsystemprocs..sp_tempdb  
read by proc sybsystemprocs..sp_shmdumpdisp  
   called by proc sybsystemprocs..sp_shmdumpconfig  
read_written by proc sybsystemprocs..sp_dbrecovery_order  
read by proc sybsystemprocs..sp_spaceused  
read_written by proc sybsystemprocs..sp_multdb_dropgroup  
   called by proc sybsystemprocs..sp_tempdb  
read by proc sybsystemprocs..sp_passwordpolicy  
   called by proc sybsystemprocs..sp_downgrade  
read by proc sybsystemprocs..sp_multdb_show  
   called by proc sybsystemprocs..sp_tempdb  
read by proc sybsystemprocs..sp_help  
read_written by proc sybsystemprocs..sp_dboption_flmode  
   called by proc sybsystemprocs..sp_dboption  
read by proc sybsystemprocs..sp_ldapadmin  
written by proc sybsystemprocs..sp_droplogin  
read by proc sybsystemprocs..sp_securityprofile  
read_written by proc sybsystemprocs..sp_multdb_addtogroup  
   called by proc sybsystemprocs..sp_tempdb  
read_written by proc sybsystemprocs..sp_makesuspect_obj  
written by proc sybsystemprocs..sp_multdb_unbindall_db  
   called by proc sybsystemprocs..sp_tempdb  
read by proc sybsystemprocs..sp_listsuspect_page  
read_written by proc sybsystemprocs..sp_addexeclass  
read_written by proc sybsystemprocs..sp_rjs_register  
read_written by proc sybsystemprocs..sp_multdb_removefromgroup  
   called by proc sybsystemprocs..sp_tempdb  
read_written by proc sybsystemprocs..sp_shmdumpconfig  
read by proc sybsystemprocs..sp_helpindex  
   called by proc sybsystemprocs..sp_help  
read by proc sybsystemprocs..sp_aux_securityprofile_getattr  
   called by proc sybsystemprocs..sp_securityprofile  
read by proc sybsystemprocs..sp_unbindcache_all  
read_written by proc sybsystemprocs..sp_modifylogin  
read_written by proc sybsystemprocs..sp_multdb_unbindall_gr  
   called by proc sybsystemprocs..sp_tempdb  
read_written by proc sybsystemprocs..sp_setsuspect_threshold  
read by proc sybsystemprocs..sp_helpdb  
read by proc sybsystemprocs..sp_rjs_retrieve  
read_written by proc sybsystemprocs..sp_addengine  
read_written by proc sybsystemprocs..sp_clearpsexe  
read_written by proc sybsystemprocs..sp_addlogin  
read by function sybsystemprocs..udf_inactivity_check  
read_written by proc sybsystemprocs..sp_forceonline_object  
read_written by proc sybsystemprocs..sp_forceonline_page  
   called by proc sybsystemprocs..sp_forceonline_db  
read by proc sybsystemprocs..sp_showexeclass  
read_written by proc sybsystemprocs..sp_fix_dtm_ha_roles  
read by proc sybsystemprocs..sp_listsuspect_db  
read_written by proc sybsystemprocs..sp_shmdumpconfig_config  
   called by proc sybsystemprocs..sp_shmdumpconfig  
read by proc sybsystemprocs..sp_helpmaplogin  
read_written by proc sybsystemprocs..sp_setsuspect_error  
read_written by proc sybsystemprocs..sp_setsuspect_granularity  
read by proc sybsystemprocs..sp_ssladmin  
read_written by proc sybsystemprocs..sp_dropengine  
read_written by proc sybsystemprocs..sp_displaylevel  
read by proc sybsystemprocs..sp_dropdevice  
read by proc sybsystemprocs..sp_encryption  
   called by proc sybsystemprocs..sp_downgrade  
written by proc sybsystemprocs..sp_dropexternlogin  
read_written by proc sybsystemprocs..sp_unbindexeclass  
read by proc sybsystemprocs..sp_activeroles  
written by proc sybsystemprocs..sp_rjs_unregister  
read by proc sybsystemprocs..sp_dboption  
read by proc sybsystemprocs..sp_locklogin  
   called by proc sybsystemprocs..sp_droplogin  
   called by proc sybsystemprocs..sp_addlogin  
read_written by proc sybsystemprocs..sp_dropexeclass  
written by proc sybsystemprocs..sp_multdb_unbind  
   called by proc sybsystemprocs..sp_tempdb  
written by proc sybsystemprocs..sp_shmdumpdrop  
   called by proc sybsystemprocs..sp_shmdumpconfig  
read_written by proc sybsystemprocs..sp_logintrigger  
   called by proc sybsystemprocs..sp_modifylogin  
read by proc sybsystemprocs..sp_listsuspect_object  
read by proc sybsystemprocs..sp_configure  
   called by proc sybsystemprocs..sp_configure  
   called by proc sybsystemprocs..sp_setlockpromote  
      called by proc sybsystemprocs..sp_setpglockpromote  
      called by proc sybsystemprocs..sp_setrowlockpromote  
read_written by proc sybsystemprocs..sp_memlog  
read_written by proc sybsystemprocs..sp_multdb_bind  
   called by proc sybsystemprocs..sp_tempdb  
read_written by proc sybsystemprocs..sp_addserver  
read_written by proc sybsystemprocs..sp_setpsexe  
read by proc sybsystemprocs..sp_displaylogin  
read by proc sybsystemprocs..sp_shmdumpsize  
   called by proc sybsystemprocs..sp_shmdumpdisp  
read by proc sybsystemprocs..sp_forceonline_db  
read by proc sybsystemprocs..sp_displayroles  
read by proc sybsystemprocs..sp_plan_dbccdb  
read_written by proc sybsystemprocs..sp_bindexeclass  
read_written by proc sybsystemprocs..sp_maplogin  
read_written by proc sybsystemprocs..sp_version  
read by proc sybsystemprocs..sp_helprotect  
read by proc sybsystemprocs..sp_helpexternlogin  
read_written by proc sybsystemprocs..sp_dropserver  
read_written by proc sybsystemprocs..sp_addexternlogin