Search column

PHOTO EMBED

Thu Jul 01 2021 14:04:39 GMT+0000 (UTC)

Saved by @Bartcw89 #sql

SELECT tb.name [Table], c.name [Column], tp.name Type
FROM sys.tables tb
JOIN sys.columns c ON tb.object_id = c.object_id
JOIN sys.types tp ON c.system_type_id = tp.system_type_id
WHERE c.name LIKE '%ColumnName%'
ORDER BY [Table], [Column];
content_copyCOPY

Searches a specified column in the database.