Tabellen und Spalten in Datenbank filtern

SELECT T1.object_id, T1.name AS Spaltenname, T2.name AS Tabelle , T3.name AS SchemaName FROM sys.columns T1

LEFT JOIN sys.tables AS T2

ON T1.object_id = t2.object_id

LEFT JOIN sys.schemas AS T3 ON T2.schema_id = T3.schema_id

where T1.name like '%Grund%' 

 

AND T3.name = 'PROVIA' 

 

0 Kommentare

Dein Kommentar

An Diskussion beteiligen?
Hinterlasse uns Deinen Kommentar!

Schreibe einen Kommentar