This is the legacy 4D documentation web site. Documentations are progressively being moved to developer.4d.com
- 4D Design Reference
-
- Creating a database structure
-
-
Database basics
-
4D Database capabilities
-
Structure editor
-
Inspector palette
-
Creating and modifying tables
-
Table properties
-
Primary key manager
-
Creating and modifying fields
-
4D field types
-
Field properties
-
External data storage
-
Rules for naming tables and fields
-
Creating and modifying indexes
-
Creating and modifying relations
-
Types of relations
-
Relation properties
-
Exporting and importing structure definitions
-
4D v19
4D Database capabilities
4D Database capabilities
The following table lists the maximum capabilities of the 4D database engine:
| Capabilities | Maximum in the 4D Engine |
| Number of tables | 32,767 |
| Number of fields per table | 32,767 |
| Number of records per table | 1 billion |
| Number of index keys per table | 128 billion |
| Size of alpha fields | 255 characters |
| Size of text fields | 2 GB |
| Size BLOB fields | 2 GB |
| Size of object fields | 2 GB |
| Number of attributes per object field | up to 128 billion* |
| Number of transaction levels | Unlimited |
* depending on the number of index keys
PROPERTIES
Product: 4D
Theme: Creating a database structure
PAGE CONTENTS
HISTORY
ARTICLE USAGE
4D Design Reference ( 4D v19)
© 1985-2025 4D SAS / 4D, Inc. All rights reserved.