>Hi,
>
>What is the syntax of command to pass to SQL Server from VFP that would allow me to get all tables of the database and for each table all fields/columns? TIA.

Take a look at the INFORMATION_SCHEMA.Tables system view and also INFORMATION_SCHEMA.Columns.

INFORMATION_SCHEMA.TABLES has all tables and views in the database and the INFORMATION_SCHEMA.Columns has information about all columns in every table in a database.