Find Microsoft SQL Server database tables which include columns using depricated data types

find-tables-columns-using-depricated-data-types.sql

-- see: https://msdn.microsoft.com/en-us/library/ms143729.aspx

SELECT 
	TABLE_SCHEMA 
	,TABLE_NAME  
	,COLUMN_NAME
	,DATA_TYPE 

FROM INFORMATION_SCHEMA.COLUMNS

WHERE DATA_TYPE IN (
		'text' 
		, 'ntext'
		, 'image'
	)
	
ORDER BY TABLE_SCHEMA, TABLE_NAME, DATA_TYPE;