Is there a way to search meta data in TDA? Many of the tables I work with have hundreds of columns and it would be great if there was a quick way to set focus on the columns I am looking for.
Not really. But if you drag on the tables to your query to the ER Diagramer and right click, there is a 'Hidden Column' manager. Here you can hide the columns that you don't need. Then send this to the Query Builder and it will retain those hidden columns.
You can save the ER Diagram as a template and send to the Query Builder for future tables with columns hidden.