DatabaseTableApplicationCreatedLinks
sybsystemprocssysattributes  31 Aug 14Joins Schema ColumnUsage Queries Dependencies

1     create table sysattributes(-- 31 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    create unique clustered index csysattributes on sysattributes(-- 2 KB refcount: 119
20        class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo
21    )
22    create index ncsysattributes on sysattributes(-- 2 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_info1]sybsystemprocs..sysattributes[object_info1]16 Simple Join
[class, attribute]master..sysattributes[object, object_info1]8 Simple Join
[class]master..sysattributes[object]8 Simple Join
[object_info2]master..spt_values[number]6 Simple Join
[object_info1, object_info2]sybsystemprocs..syscolumns[id, colid]2 Simple Join
[object]sybsystemprocs..sysindexes[id]2 Simple Join

Estimated Index Usage
sysattributes.csysattributes unique clustered(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)119
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
6652222174

SCHEMA

COLUMN USAGE
classsp_addobjectdef  sp_add_qpgroup  sp_aux_encr_verify_downgrade  sp_aux_get_qpgroup  sp_aux_sys_encr_passwd_lookup  sp_bindcache  sp_bindexeclass  sp_config_rep_agent  sp_droplockpromote  sp_dropobjectdef  sp_dropuser  sp_drop_qpgroup  sp_encryption  sp_help  sp_helpindex  sp_helpobjectdef  sp_help_qpgroup  sp_logiosize  sp_passwordpolicy  sp_rename  sp_rename_qpgroup  sp_replication_path  sp_setlockpromote  sp_showcontrolinfo  sp_spaceused  sp_ssladmin  sp_unbindexeclass 
attributesp_addobjectdef  sp_add_qpgroup  sp_aux_encr_verify_downgrade  sp_aux_get_qpgroup  sp_aux_sys_encr_passwd_lookup  sp_bindcache  sp_bindexeclass  sp_config_rep_agent  sp_droplockpromote  sp_dropobjectdef  sp_drop_qpgroup  sp_encryption  sp_help  sp_helpindex  sp_helpobjectdef  sp_help_qpgroup  sp_logiosize  sp_rename  sp_rename_qpgroup  sp_replication_path  sp_setlockpromote  sp_spaceused  sp_unbindexeclass 
object_typesp_addobjectdef  sp_add_qpgroup  sp_aux_get_qpgroup  sp_aux_sys_encr_passwd_lookup  sp_bindcache  sp_bindexeclass  sp_config_rep_agent  sp_droplockpromote  sp_dropuser  sp_drop_qpgroup  sp_encryption  sp_help  sp_helpindex  sp_help_qpgroup  sp_logiosize  sp_rename_qpgroup  sp_replication_path  sp_setlockpromote  sp_showcontrolinfo  sp_spaceused  sp_unbindexeclass 
object_cinfosp_addobjectdef  sp_add_qpgroup  sp_aux_get_qpgroup  sp_aux_sys_encr_passwd_lookup  sp_bindexeclass  sp_config_rep_agent  sp_dropobjectdef  sp_dropuser  sp_help  sp_helpobjectdef  sp_help_qpgroup  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_droplockpromote  sp_dropuser  sp_drop_qpgroup  sp_encryption  sp_help  sp_helpindex  sp_help_qpgroup  sp_logiosize  sp_passwordpolicy  sp_rename  sp_rename_qpgroup  sp_replication_path  sp_setlockpromote  sp_showcontrolinfo  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_showcontrolinfo  sp_unbindexeclass 
object_info2sp_addobjectdef  sp_aux_sys_encr_passwd_lookup  sp_encryption  sp_help  sp_helpobjectdef  sp_replication_path  sp_setlockpromote 
object_info3sp_addobjectdef  sp_rename  sp_setlockpromote  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_replication_path  sp_setlockpromote  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:462
master..sysattributes master..sysattributes sybsystemprocs..sysindexes sybsystemprocs..sp_spaceused:267
master..sysattributes master..sysattributes sybsystemprocs..sp_help:710
master..sysattributes master..sysattributes sybsystemprocs..sp_spaceused:535
sybsystemprocs..sp_help:852
sybsystemprocs..sp_encryption:2831
sybsystemprocs..sp_encryption:1406

DEPENDENCIES
READERS AND WRITERS
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_config_rep_agent  
read_written by proc sybsystemprocs..sp_bindexeclass  
read_written by proc sybsystemprocs..sp_dropobjectdef  
   called by proc sybsystemprocs..sp_droptabledef  
read_written by proc sybsystemprocs..sp_logiosize  
read_written by proc sybsystemprocs..sp_setlockpromote  
   called by proc sybsystemprocs..sp_setpglockpromote  
   called by proc sybsystemprocs..sp_setrowlockpromote  
read by proc sybsystemprocs..sp_ssladmin  
read_written by proc sybsystemprocs..sp_add_qpgroup  
   called by proc sybsystemprocs..sp_import_qpgroup  
read by proc sybsystemprocs..sp_passwordpolicy  
   called by proc sybsystemprocs..sp_downgrade  
read by proc sybsystemprocs..sp_showcontrolinfo  
read_written by proc sybsystemprocs..sp_addobjectdef  
   called by proc sybsystemprocs..sp_addtabledef  
written by proc sybsystemprocs..sp_drop_qpgroup  
read_written by proc sybsystemprocs..sp_bindcache  
   called by proc sybsystemprocs..sp_unbindcache  
read by proc sybsystemprocs..sp_aux_sys_encr_passwd_lookup  
read_written by proc sybsystemprocs..sp_dropuser  
read by proc sybsystemprocs..sp_helpobjectdef  
read by proc sybsystemprocs..sp_help_qpgroup  
read by proc sybsystemprocs..sp_help  
read by proc sybsystemprocs..sp_encryption  
   called by proc sybsystemprocs..sp_downgrade  
read_written by proc sybsystemprocs..sp_rename  
read_written by proc sybsystemprocs..sp_droplockpromote  
   called by proc sybsystemprocs..sp_dropglockpromote  
   called by proc sybsystemprocs..sp_droprowlockpromote  
read by proc sybsystemprocs..sp_aux_get_qpgroup  
   called by proc sybsystemprocs..sp_export_qpgroup  
   called by proc sybsystemprocs..sp_copy_qplan  
      called by proc sybsystemprocs..sp_copy_all_qplans  
   called by proc sybsystemprocs..sp_add_qpgroup  
   called by proc sybsystemprocs..sp_find_qplan  
   called by proc sybsystemprocs..sp_rename_qpgroup  
   called by proc sybsystemprocs..sp_drop_all_qplans  
   called by proc sybsystemprocs..sp_copy_all_qplans  
   called by proc sybsystemprocs..sp_cmp_all_qplans  
   called by proc sybsystemprocs..sp_help_qpgroup  
   called by proc sybsystemprocs..sp_import_qpgroup  
   called by proc sybsystemprocs..sp_drop_qpgroup  
read by proc sybsystemprocs..sp_spaceused  
read by proc sybsystemprocs..sp_aux_encr_verify_downgrade  
read_written by proc sybsystemprocs..sp_unbindexeclass  
read by proc sybsystemprocs..sp_replication_path