根据关键字查询表字段

SELECT DISTINCT tb.name AS TableName,c.name AS ColumnName,t.name AS Type
FROM sys.columns c
JOIN sys.types t ON c.system_type_id = t.system_type_id
JOIN sys.tables tb ON c.object_id = tb.object_id
WHERE c.name LIKE '%dep%'
AND tb.name NOT LIKE '%备份%'
ORDER BY TableName;