WHERE column_name in ('col1', 'col2')
Obviously object `DB_NAME.COLUMNS` doesn't exist and even `DB_NAME.tables`. Any further ideas?
So the solution is:
WHERE DatabaseName = 'DB_NAME' and
ColumnName in ('col1', 'col2')
Please change the view to dbc.ColumnsV, dbc.Columns is an old legacy version, deprecated since TD12. Starting with TD14.10 it might return wrong results if object names longer than 30 characters are used...