# Limitations for database manager values

Table 1. Database manager limitations. The following table lists limitations on various Database Manager values in Derby.
Value | Limit
--- | ---
Maximum columns in a table | 1,012
Maximum columns in a view | 5,000
Maximum number of parameters in a stored procedure | 90
Maximum indexes on a table | 32,767 or storage capacity
Maximum tables referenced in an SQL statement or a view | storage capacity
Maximum elements in a select list | 1,012
Maximum predicates in a WHERE or HAVING clause | storage capacity
Maximum number of columns in a GROUP BY clause | 32,677
Maximum number of columns in an ORDER BY clause | 1,012
Maximum number of prepared statements | storage capacity
Maximum declared cursors in a program | storage capacity
Maximum number of cursors opened at one time | storage capacity
Maximum number of constraints on a table | storage capacity
Maximum level of subquery nesting | storage capacity
Maximum number of subqueries in a single statement | storage capacity
Maximum number of rows changed in a unit of work | storage capacity
Maximum constants in a statement | storage capacity
Maximum depth of cascaded triggers | 16

Parent topic: Derby limitations
Related reference
DATE, TIME, and TIMESTAMP limitations
Limitations on identifier length
Numeric limitations
String limitations
XML limitations