Suche nach Spaltennamen in einer DB SELECT 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 UPPER(C.NAME) -- LIKE '%ID%' LIKE 'ACCOUNT%ID' OR UPPER(C.NAME) LIKE 'OWNER%ID' OR UPPER(C.NAME) LIKE 'USER%ID' OR UPPER(C.NAME) LIKE 'LOGIN%ID' ORDER BY COLUMN_NAME, SCHEMA_NAME, TABLE_NAME Suche nach Tabellennamen