Ask Learn
PreviewPlease sign in to use this experience.
Sign inIntroduction
100 XP
Tables are the fundamental objects in any database. In this module, you learn about the different types of tables that are available in Microsoft Dynamics 365 Business Central by technical implementation and functional use.
You learn how to create and configure tables and their properties. Additionally, you discover how to define fields in a table and about the different available data types.
Dynamics 365 Business Central uses a relational database management system (RDBMS), where you can have relations between different tables. In Business Central, you can also manage relations in your table definitions.
You also learn how to create primary and secondary keys and some best practices on how to use them.
Finally, you learn how to use the calculated fields feature. These fields (called FlowFields) aren't stored in the database; instead, they're calculated each time they're needed. You'll discover the different calculation possibilities and learn how to use them in Visual Studio Code.