Sql Server Find Column with datatype

SELECT column_name from information_schema.columns
WHERE table_name LIKE ‘%Login%’
AND data_type like ‘varchar’
ORDER BY column_name

Leave a comment