Table Specifications

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