Dynamiclly Delete Data With Multiple Table

DECLARE
@EXECUTEQUERY VARCHAR(MAX)='',
@TableNameComma VARCHAR(MAX)='TABLENAME'
AS 
--SELECT @TableNameComma
BEGIN
     
SELECT @EXECUTEQUERY+= 'DELETE FROM [' + s.name + '].[' + t.name + ']' + CHAR(10)  FROM sys.tables t  
INNER JOIN  sys.schemas s ON s.schema_id = t.schema_id
WHERE t.name IN (select CAST(Item AS VARCHAR(max)) from dbo.SplitString(@TableNameComma,',')  )  

--PRINT @EXECUTEQUERY
SELECT @EXECUTEQUERY
--EXEC (@EXECUTEQUERY)
 END