select CONCAT('TRUNCATE TABLE ', TABLE_SCHEMA, '.', table_name,';') from information_schema.tables where TABLE_SCHEMA in ('saas');