DatabaseTableApplicationCreatedLinks
mastersystimeranges  31 Aug 14Joins Schema ColumnUsage Queries Dependencies

1     create table systimeranges(-- 0 Rows, Data: 2 KB, Index: 4 KB
2         name varchar(255) not null,
3         id smallint not null,
4         startday tinyint not null,
5         endday tinyint not null,
6         starttime varchar(10) not null,
7         endtime varchar(10) not null
8     )
9     
10    create clustered index csystimeranges on systimeranges(-- 2 KB refcount: 13
11        id
12    )
13    
14    alter table systimeranges lock datarows
15    
16    Grant Select on systimeranges to public
17    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[id]master..sysresourcelimits[rangeid]4 Simple Join

Estimated Index Usage
systimeranges.csystimeranges clustered(id)13

ALIASES USED for master..systimeranges
NO_ALIASrsystimeranges
3125

SCHEMA

COLUMN USAGE
namesp_add_resource_limit  sp_add_time_range  sp_drop_resource_limit  sp_drop_time_range  sp_help_resource_limit  sp_modify_resource_limit  sp_modify_time_range 
idsp_add_resource_limit  sp_add_time_range  sp_drop_resource_limit  sp_drop_time_range  sp_gen_timerange_id  sp_help_resource_limit  sp_modify_resource_limit  sp_modify_time_range 
startdaysp_add_resource_limit  sp_add_time_range  sp_help_resource_limit  sp_modify_time_range 
enddaysp_add_resource_limit  sp_add_time_range  sp_help_resource_limit  sp_modify_time_range 
starttimesp_add_resource_limit  sp_add_time_range  sp_help_resource_limit  sp_modify_time_range 
endtimesp_add_resource_limit  sp_add_time_range  sp_help_resource_limit  sp_modify_time_range 

QUERIES
Joined With Links
master..sysresourcelimits sybsystemprocs..sp_help_resource_limit:171
sybsystemprocs..sp_help_resource_limit:116

DEPENDENCIES
READERS AND WRITERS
read_written by proc sybsystemprocs..sp_drop_time_range  
read by proc sybsystemprocs..sp_gen_timerange_id  
   called by proc sybsystemprocs..sp_add_time_range  
read by proc sybsystemprocs..sp_modify_resource_limit  
read by proc sybsystemprocs..sp_add_resource_limit  
read by proc sybsystemprocs..sp_help_resource_limit  
read_written by proc sybsystemprocs..sp_add_time_range  
read by proc sybsystemprocs..sp_drop_resource_limit  
read_written by proc sybsystemprocs..sp_modify_time_range