Agreed...

>I doubt VFP will get this in light of the tools in VStudio. Frankly,
>I don't think it's necessary either. As long as we can do it via
>code I don't need the functionality in the box.
>
>
>>Short of using SQL PassThrough (SPT) - and using constructs like Alter Table - I am not aware of any other method. SQL Server can be controlled via automation - but I have not spent time investigating how powerul the interface is.
>>
>>VB and some other tools in VS have capacity to do what you want visually via OLE-DB. Access 2000 will be a great front-end for SQL Server when it ships. I agree it would be nice to have those capabilities in VFP.
>>
>>>Anyone knows is there a way to edit/modify Table Structure
>>>in VFP environment once the database is upsized to
>>>MS SQL 6.5? Thanks!