Page Comparison

SELECT 'truncate table ' + TABLE_NAME + ';' char(10) + 'go'
FROM SEMARCHY_PRODUCT_RETAIL_MDM.INFORMATION_SCHEMA.TABLES   /* amend Database Name to your database */
WHERE TABLE_NAME NOT LIKE 'DL_%' 
AND   TABLE_NAME NOT LIKE 'EXT_%'   /* Don't truncate these Semarchy system tables starting with DL and EXT */
AND   TABLE_NAME LIKE '%BRAND'      /* amend this line to meet your needs */
ORDER BY SUBSTRING(TABLE_NAME, 1, 3), TABLE_NAME
;

truncate table AE_BRAND;
go
truncate table GD_BRAND;
go
truncate table GH_BRAND;
go
truncate table GX_BRAND;
go
truncate table SA_BRAND;
go