'Exporting" certain blocked tables from AX

I was looking to export the AX tables




Into a file. i have no intention of reimporting them. Just wanted to learn the patterns. When I attempted to do this with the Export function in AX, the function “worked” but no data were returned to the destination file. I learned reading


That these tables are “blocked” and cannot be exported. I certainly could guess why this might be – AX doesn’t want one to attempt to re-import them into another instance and corrupt it – but how would someone get this information for the purpose I described some other way? Is there some “magic SQL” statement I can run in the database? The simplest answer would be the best one.

For example, open the table on table browser and press Ctrl+T (= export to Excel). Other options include Data import/export framework and SQL Server Import and Export Wizard.