You may want to take a look at SQL DMO.
DMO stands for Data Manipulation Object and it comes in the form of a DLL. You can instanciate SQLDMO from within FoxPro and get all type of SQL Server information from it, including tables, fields, and so forth.
DMO is supposed to provide all the information that you can usually get by reading the "sys" tables, yet, it is easier to use.
>Hi, everybody!
>
>Is there someway to get information of SQL Tables? For example: I need to, given a SQL table, identifie every fields, captions, datatypes, width, etc... as we easily do on VFP...
>
>Does anybody can tell me how could I do that?
>
>Thanks in advance.
Hector Correa