>How can I open a SQLServer table in Foxpro with all its properties.
>Especially indexes.
You can't in the fashion that you operate on a native VFP table - you pass commands to SQL Server, which executes them and passes back a result. The result set is disconnected from the client side representation of the data - IOW, VFP doesn't direct;y manipulate SQL Server; it sends standard commands to SQL Server that are performed on its behalf, and the VFP app is completely unaware of the underlying indexes, physical data representations and the like - if you receive a view or cursor based on SQL Server data, the result is disconnected from SQL Server's underlying data management implementation. If you use ADO, you get an ADO recordset object. The database on the backend is not available for direct access by the client app - you operate on the results of requests handled by the server backend.