Object Specifications and Limitations

This article 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.

FeatureCharacteristic
Maximum number of physical disk files32,767
Database file size524,272 terabytes
Maximum number of objects in a database2,147,483,647
Maximum number of characters in application object names30
Maximum number of characters in a Database Authentication password80

Specifications for Tables

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

FeatureCharacteristic
Range for table object ID numbers1 – 999,999,999 1
Maximum number of characters in a table name30
Maximum table sizeDepends on available storage
Maximum number of records in a tableDepends on available storage
Maximum record size8060 bytes2
Maximum number of fields in a record500
Range for field numbers1 – 999,999,999
Maximum size of a Business Central key900 bytes
Maximum number of distinct fields per key16
Maximum size of an (non-key) index1700 bytes
Maximum number of SumIndexFields per key20
Maximum number of characters in a text or code field2048
Maximum size of a BLOB field2 GB
Maximum number of characters in a field name30

Specifications for Pages and Reports

FeatureCharacteristic
Range for page or report object ID numbers1 – 999,999,999 1
Maximum number of characters in a caption1024
Maximum bitmap size in bitmap property32500 bytes

Specifications for Codeunits

FeatureCharacteristic
Range for codeunit object ID numbers1 – 999,999,999 1
Maximum physical size of a codeunit2 GB

Specifications for variables

FeatureCharacteristic
Maximum number of characters in variable names120
Maximum number of characters in text variables20483
Maximum number of characters in code variables2048
Maximum number of dimensions in array variables10
Maximum number of elements in an array variable1,000,000
Lower bound of index in an array1

Specifications for text constants

FeatureCharacteristic
Maximum number of characters2048

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.

2Each variable-length text field accounts for 26 bytes in the record.

3 If no length is specified for text variables, the length is unlimited.

Field Data Types
Maximum Capacity Specifications for SQL Server