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