Zoeken op velden en waarden in een database

SELECT ‘T’ AS type, t.name AS table_name, SCHEMA_NAME(schema_id) AS schema_name, c.name AS column_name
FROM sys.tables AS t INNER
JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
WHERE c.name = ‘veld’ UNION ALL SELECT ‘V’ AS type, t.name AS table_name, SCHEMA_NAME(schema_id) AS schema_name, c.name AS column_name
FROM sys.views AS t INNER
JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
WHERE c.name = ‘veld’
ORDER BY schema_name, table_name