While working with D365 F&O I often have to delete test data from several tables with a prefix or suffix. The following SQL script helps a lot to generate the truncate commands for these tables. For example to empty all staging tables from a BYOD.
DECLARE @suffix NVARCHAR(50) = 'staging';
SELECT TABLE_SCHEMA, TABLE_NAME, 'truncate table ' + TABLE_NAME as SQLCommand
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME LIKE '%' + @suffix;
