Need to edge out the competition for your dream job? Train for certifications today.
SELECT t.name as table_name, c.name as column_name, c.*
FROM sys.tables t
JOIN sys.columns c ON t.object_id = c.object_id
JOIN sys.types ty ON c.user_type_id = ty.user_type_id
WHERE ty.name IN ('binary', 'image')
ORDER BY t.name, c.name
Open in new window
SELECT TABLE_NAME, COLUMN_NAME
WHERE DATA_TYPE IN ('varbinary','binary','image')
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment
From novice to tech pro — start learning today.
Premium members can enroll in this course at no extra cost.