# 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.
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 2019. 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 bytes2
Maximum number of fields in a record|500
Range for field numbers|1 - 999,999,999
Maximum size of a Business Central 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|2048
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 codeunit object ID numbers|1 - 999,999,999 1
Maximum physical size of a codeunit|2 GB
## Specifications for variables
Feature|Characteristic
Maximum number of characters in variable names|120
Maximum number of characters in text variables|20483
Maximum number of characters in code variables|2048
Maximum number of dimensions in array variables|10
Maximum number of elements in an array variable|1,000,000
Lower bound of index in an array|1
## Specifications for text constants
Feature|Characteristic
Maximum number of characters|2048
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.
## Related information
Field Data Types<methods-auto/library>
https://learn.microsoft.com/sql/sql-server/maximum-capacity-specifications-for-sql-server

Copyright (c) Microsoft Corporation. CC BY 4.0, https://creativecommons.org/licenses/by/4.0/; code samples MIT. From https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-object-specifications-limitations, MicrosoftDocs/dynamics365smb-devitpro-pb at 828b6ee (2026-11-19). Changed: includes filled in, links to this site, and for agents shortened without dropping a fact. https://jonas-paprotka.de/docs/dev-itpro/developer/devenv-object-specifications-limitations/
