Testabfragen
Mit den folgenden Testabfragen eine Tabellenspalte über alle Tabellen einer Datenbank auflisten.
SELECT
t.name AS TableName,
c.name AS ColumnName
FROM sys.columns c
JOIN sys.tables t ON c.object_id = t.object_id
WHERE c.name LIKE 'ITEMID' -- or = 'differentColumn'
and t.name like '%prod%'
ORDER BY t.name, c.column_id;
SELECT
t.name AS TableName,
c.name AS ColumnName,
ep.value AS ColumnDescription
FROM sys.columns c
JOIN sys.tables t
ON c.object_id = t.object_id
LEFT JOIN sys.extended_properties ep
ON ep.major_id = c.object_id
AND ep.minor_id = c.column_id
AND ep.name = 'MS_Description'
WHERE c.name LIKE '%jljworkformissingpart%'
ORDER BY t.name, c.column_id;
