I need to write a routine to update the structure of a SQL Server table from a VFP app.

The changes I need to make are relatively simple, probably just FieldName, FieldType, Default value. Fields may be added, dropped or modified, including posibly casting to a different type.

Any suggestions or gotchas?

TIA,

Alex