MSSQL Reader - How to detect underlying DB table schema changes?

Hi Guys,

New to FME but really enjoying the journey to date. Today I hit my first confusing issue which although I have resolved I am pretty sure they must be a better way.

I had:

• Created an MSSQL table
• Created an FME reader which detected the schema including attribute types and so forth.
• Did some processing and wrote to a file geodatabase.

But:

• I then made some minor changes to the underlying MSSQL table i.e. changed text to decimal etc.
• However the reader would not detect these changes. I had to delete and recreate the reader for then changed to be detected.

Is there some easier method which I am missing to get the reader to detect changes to the table schema in the database?

Apologies in advance if the solution is simple but I am missing it!

Thanks,

Barry.