4D v20.1
4D Database capabilities
- 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 v20.1
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 v20)
4D Design Reference ( 4D v20.1)
© 1985-2023 4D SAS / 4D, Inc. All rights reserved.