Modifying Import Specs and its Effect to Queries

[oldevilla]

Due to the new format of the input text file, I modified the import
specification of my tool. I basically deleted a column named RECORD. Thus,
the new import specification consequently affects the structure of table. The
new table has no RECORD column.

My assessment is that my tool should not be affected adversely. In terms of
the succeeding queries, not a single query refers to the RECORD column. So I
believe I can still get the same results after modifying the import
specifications.

To summarize, if a column is not referred to by any query, is it ok to just
delete that column?

 

[Guest]

If that column is not used anywhere, then it should be OK to just delete it.

However I recommend creating a copy of your database and testing it there.
After dropping the column, run every query, form, or report and see if any
error messages pop up.