Most simplified form 🙂

SELECT '['+SCHEMA_NAME(SCHEMA_ID)+'].['+name+']' TableName

FROM Sys.tables WHERE name NOT IN (

SELECT Distinct ic.TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS ic

WHERE ic.DATA_TYPE IN('text', 'ntext', 'image')

OR CHARACTER_MAXIMUM_LENGTH = '-1')

Aqeel Ahmed