/*
12.03.2025, TSC
*/
USE [dba_reporting]

DECLARE @q NVARCHAR(MAX)='';

SELECT @q = @q + 'DELETE FROM '+SCHEMA_NAME(t.[schema_id])+'.'+t.[name]+';'+CHAR(13)+CHAR(10)
--SELECT name, [t].[schema_id], 'DELETE FROM '+SCHEMA_NAME(t.[schema_id])+'.'+t.[name]+';'+CHAR(13)+CHAR(10) AS cmd
FROM sys.[tables] t
WHERE t.[name] LIKE 'sym_%';

PRINT @q
--EXEC(@q)