-- This will generate SQL to count the number of records in a list of AX tables, per DATAARERAID
DECLARE c CURSOR FOR
SELECT
  a.name
FROM TEMPDB.SYS.TABLES(NOLOCK) a
WHERE (LEN(NAME) > 30 AND LEN(NAME) < 50)
AND ((SUBSTRING(A.NAME,1,3) = 'DMF') OR (SUBSTRING(A.NAME,1,1) = 'T'))
AND A.is_ms_shipped = 0
AND A.modify_date < (GETDATE() -3)

DECLARE @tabname varchar(128)
DECLARE @sqlstring nvarchar(255)

OPEN c
FETCH NEXT FROM c INTO @tabname

WHILE @@FETCH_STATUS = 0
BEGIN
  SET @sqlstring = 'DROP TABLE TEMPDB.DBO ' + @tabname
  PRINT @sqlstring
  --exec (@sqlstring)
  FETCH NEXT FROM c INTO @tabname
END

CLOSE c
DEALLOCATE c