Table definition

With the AL extension, you don't have a graphical tool for designing tables (like we did previously in CSIDE); instead, you need to create a table using code.

A table definition can be created by using the ttable snippet:

table id MyTable{        DataClassification = ToBeClassified;    fields    {        field(1;MyField; Integer)        {            DataClassification = ToBeClassified;                  }    }       keys    {        key(PK; MyField)        {            Clustered = true;        }    }       var        myInt: Integer;       trigger OnInsert()    begin           end;    trigger OnModify()    begin           end;       trigger OnDelete()    begin           end;       trigger OnRename()    begin           end;   }

To define a table, you need to specify an ID (which must be unique in your application) and a name (which must also be unique). Then, you can set the table's properties (use ...

Get Mastering Microsoft Dynamics 365 Business Central now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.