Temporary Tables in Business Central A temporary tab le is a temporary variable that holds a table. A temporary table is used as a buffer or intermediate storage for table data. You can use a temporary table just like you use a database table. The differences between a temporary table and a database table are as follows: A temporary table of data isn't stored in the database. It's only held in memory until the table is closed. The write transaction principle that applies to a database table doesn't apply to a temporary table. Today one of my colleagues addressed me with an issue: all the records are deleted in the sales price table while applying the original prices. After Analyzing the Code, I found that the developer had missed setting the Temporary property to Yes while declaring the variable, due to which the table was considered as a Physical table and deleted the data from the database. In this post, I’ll address some common misconceptions and gi...