SAP ASE version 16.0 increases some column and table restrictions.
| Limit | Limit in Versions Earlier Than 16.0 | Limit in Versions 16.0 and Later |
|---|---|---|
| Number of tables in select queries | 50 tables, 46 worktables | 250 tables, 46 worktables |
| Number of subqueries in a select query | 50 | 250 |
| Maximum number of columns allowed in an order by clause | 31 | 400 |