+6Hi
I need to add a field to a SQL table as the schema has changed. However, all the instructions indicate I need to drop the table. As there is data in there already, I cannot do this. Is there a way to add the column in FME, or should I just go into SQL Server Management Studio?
Best answer by markatsafe
@markcoopersdc It's probably easier to run your ALTER TABLE in SQL Server Management Studio, but you could trigger ALTER TABLE using the SQLExecutor if you wanted.
@markcoopersdc It's probably easier to run your ALTER TABLE in SQL Server Management Studio, but you could trigger ALTER TABLE using the SQLExecutor if you wanted.
+6Thank you, I didn't think of using the SQLExecutor but, as you say, I think it is easier to run it in SQL Server Management Studio
