USE POLARIS

-- Search column and table names to find specific text
-- The version below checks for text in 2 separate columns, and a table name; table 'c2' can be commented out to search for only 1 column name


SELECT      c.name  AS 'ColumnName'
            ,c2.name As '2nd ColumnName'
            ,t.name AS 'TableName'
FROM        sys.columns c
INNER JOIN  sys.tables  t   
    ON c.object_id = t.object_id
INNER JOIN sys.columns c2
    ON c2.object_id = t.object_id
WHERE c.name LIKE '%Auth%ID%' -- column name filter
AND c2.Name LIKE '%Bib%ID%' -- second column name filter
AND t.name not like '%Import%' -- table name filter
ORDER BY    TableName
            ,ColumnName;