Newly added Column in Table that Query is not pulling
Posted on 2014-04-19
is there a way to compare a query definition to a table definition and tell if the query is missing any newly added column from the table.
Reason - i have a query that pulls all the columns from that same table but renames all of them to increase readability. I cant store the readable columns as headers in the original table as they have special characters and spaces in them.
so the only way is to >> create query to pull those renamed columns by the column names i need.
now bad news - if a new column is added to table, the query has to be updated to include that new column too
so is there query or vba to tell me what columns are in table1 which are not getting pulled by query?