Archiv des Tages: 13. Januar 2026

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;