How do you search text in all columns in SQL Server Tables

SELECT COLUMN_NAME, TABLE_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME LIKE ‘%findtext%’

Add Comment