Left joins , extra join and checks can be ommitted in order to make it more simple. Here is the version i m referring to

WITH column_compare AS (

SELECT

src_col.TABLE_NAME...

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

More 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

INNER JOIN Sys.tables st ON ic.TABLE_NAME=st.name

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

OR CHARACTER_MAXIMUM_LENGTH = '-1')