Introduction
Tables are the fundamental objects in any database. In this module, you will learn about the different types of tables that are available in Microsoft Dynamics 365 Business Central by technical implementation and functional use.
You'll learn how to create and configure tables and their properties. Additionally, you'll 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'll also learn how to create primary and secondary keys and some best practices on how to use them.
Finally, you'll learn how to use the calculated fields feature. These fields (called FlowFields) are not stored in the database; instead, they are calculated each time they're needed. You will discover the different calculation possibilities and learn how to use them in Visual Studio Code.