Table specifications defines requirements for items such as indexes, rows, and columns per table.
| Item | Requirement | Notes |
|---|---|---|
|
User objects per database |
231 – 255 |
|
|
Indexes per table |
250 (one clustered index) |
|
|
Rows per table |
Limited by available storage |
Maximum 232 |
|
Columns per composite index |
31 |
|
|
Creation of clustered index |
1.2*(x + y) x = total data space in table, y = sum of space of all nonclustered indexes on table, and 20 percent overhead for logging |
For sorted data, approximately 20 percent of the table size needed |
|
Maximum size of object name |
255 |