How to Truncate Table from AX 2009? May 19, 2012 1- go to the administration module 2- go to periodic menu 3- choose the SQL administration 4- choose the table you want truncate it from the all table collapse 5- click on the table action button 6- select truncate 7- click OK Read more