>I have a table that is already being used in an installation. I need to modify the table structure to repair a bug and remove an unneeded field. The only way I know how to modify table structures is to use the Project Manager but that is NOT available on the clients site.
>
>#1 - How do I change an existing field type from character 15 to integer 4?
>
>#2 - How do I remove a field from the a table?
>
>#3 - How do I add a field to a table?
>
>#4 - I assume I am updating the clients existing database (somehow), but if I make these changes - what do I need to copy to the clients system (.dbc, .exe, ...)?
>
>
>Thanks
Stonefield Data Tools does exactly what you want.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer