Share via


Object Specifications and Limitations

This topic describes the specifications and limitations for the database and application objects.

Specifications for the Database

The following characteristics are based on maximum capacity specifications for SQL Server 2017. Please visit the link below to see specifications for previous versions of SQL Server.

Feature Characteristic
Maximum number of physical disk files 32,767
Database file size 524,272 terabytes
Maximum number of objects in a database 2,147,483,647
Maximum number of characters in application object names 30
Maximum number of characters in a Database Authentication password 80

Specifications for Tables

The following characteristics are based on maximum capacity specifications for SQL Server 2017. Please visit the link below to see specifications for previous versions of SQL Server.

Feature Characteristic
Range for table object ID numbers 1 – 999,999,999 1
Maximum number of characters in a table name 30
Maximum table size Depends on available storage
Maximum number of records in a table Depends on available storage
Maximum record size 8060 bytes
Maximum number of fields in a record 500
Range for field numbers 1 – 999,999,999
Maximum number of keys for a table 40
Maximum size of a Dynamics NAV key 900 bytes
Maximum number of distinct fields per key 16
Maximum size of an (non-key) index 1700 bytes
Maximum number of SumIndexFields per key 20
Maximum number of characters in a text or code field 250
Maximum size of a BLOB field 2 GB
Maximum number of characters in a field name 30

Specifications for Pages and Reports

Feature Characteristic
Range for page or report object ID numbers 1 – 999,999,999 1
Maximum number of characters in a caption 1024
Maximum bitmap size in bitmap property 32500 bytes

Specifications for Codeunits

Feature Characteristic
Range for table object ID numbers 1 – 999,999,999 1
Maximum number of characters in variable names 30
Maximum number of dimensions in array variables 10
Maximum number of elements in an array variable 1,000,000
Maximum physical size of a codeunit 2 GB
Lower bound of index in an array 1

1All application objects are identified by an ID number. There are restrictions, however, on the numbers you can use when you create your own application objects. Review your Partner License Agreement for more information.

See Also

Objects
Field Data Types
Maximum Capacity Specifications for SQL Server