| Database | Table | Application | Created | Links |
| master | sysresourcelimits | ![]() | 31 Aug 14 | Joins Schema ColumnUsage Queries Dependencies |
1 create table sysresourcelimits(-- 0 Rows, Data: 0 B, Index: 0 B 2 name varchar(30) null, 3 appname varchar(30) null, 4 rangeid smallint not null, 5 limitid smallint not null, 6 enforced tinyint not null, 7 action tinyint not null, 8 limitvalue int not null, 9 scope tinyint not null, 10 spare tinyint not null 11 ) 12 13 create clustered index csysresourcelimits on sysresourcelimits(-- 2 KB refcount: 14 14 name, appname 15 ) 16 17 alter table sysresourcelimits lock datarows 18 19 Grant Select on sysresourcelimits to public 20
| JOINS | ||||||||||||||||||
|
| Estimated Index Usage | |
| sysresourcelimits.csysresourcelimits clustered(name, appname) | 14 |
| ALIASES USED for master..sysresourcelimits | ||||
| NO_ALIAS | a | b | l | sysresourcelimits |
| 6 | 1 | 1 | 2 | 4 |
| SCHEMA |
![]() |
| QUERIES | |
| Joined With | Links |
| sybsystemprocs..sp_modify_time_range:256 | |
| master..systimeranges | sybsystemprocs..sp_help_resource_limit:171 |
| sybsystemprocs..sp_help_resource_limit:116 | |
| DEPENDENCIES |
| READERS AND WRITERS read_written by proc sybsystemprocs..sp_add_resource_limit written by proc sybsystemprocs..sp_droplogin read_written by proc sybsystemprocs..sp_modify_resource_limit read_written by proc sybsystemprocs..sp_drop_resource_limit read by proc sybsystemprocs..sp_drop_time_range read by proc sybsystemprocs..sp_modify_time_range read by proc sybsystemprocs..sp_help_resource_limit |